Order by "order"?

Results 1 to 2 of 2

Thread: Order by "order"?

  1. #1
    Join Date
    Dec 1969

    Default Order by "order"?

    Hey,<BR>If anyone remembers their high school biology, you might remember that animals are divided up by Kingdom, Phylum, Class, Order, Genus, Species...<BR><BR>Anyways, I&#039;ve got some DB results that I would like to order by ... "order". This seems to confuse my computer - I can order by any other field, just not "order". I&#039;m assuming it&#039;s a reserved word. Is there a way I can work around this? The fields cannot be changed in the DB...<BR><BR>Thanks,<BR>Mike<BR><BR>ETdata ="SELECT * FROM ET "_<BR>& "WHERE elcode like &#039;"& taxa & "%&#039;"_<BR>& "Order By order"

  2. #2
    Join Date
    Dec 1969

    Default Use brackets...

    &nbsp;<BR>OF course its a reserved word...<BR>ORDER BY somefield....<BR><BR>ETdata ="SELECT * FROM ET "_ <BR>& "WHERE elcode like &#039;"& taxa & "%&#039;"_ <BR>& "Order By [order]"<BR><BR>OR<BR>ET.[order]<BR><BR>[] sq brackets will force it to treat the word as a field name...<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts