Re: sorting bug

From: Georg Horn (horn@koblenz-net.de)
Date: Wed Dec 22 1999 - 02:09:10 EST


Annette wrote:
> > but "select * from table order by field1,field2 desc"
> > doesn't work. It just sorts ascending... :-(
>
> what you describe above is sort by field1 ascending and field2
> descendign. If you want your data to be sorted by field1 desc and field2
> desc you have to write:
>
> "select * from table order by field1 desc, field2 desc"

Ouch. That was a stupid one. And that from me... ;-)

Bye,
Georg

-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/



This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:04:03 EST