Hi Georg,
> i think i have found a bug with sorting _descending_ in msql.
>
> A "select * from table order by field1 desc" works fine,
> 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"
HTH
Annette
-- Annette Maile Computing Center University of Stuttgart Online Publications of the University of Stuttgart: http://www.uni-stuttgart.de/opus/ ------------------------------------------------------------------------- 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