ORDER BY DESC not working

chand012 · Post by **chand012** » Thu Mar 22, 2001 11:59 am

I need to use an SQL statement of the form:

"select firstname, middlename, lastname from tbl where lastname like 'carter' order by lastname, firstname, middlename DESC"

I have normal indexes on the three name fields and a metamorph index on lastname. This command, however, does not produce the expected results, either at the command line or with WebScript. I tried creating metamorph indexes on the other name fields (just for the hell of it) but that didn't help.

What could be going wrong here?

Thanks,
David

Post by **mark** » Thu Mar 22, 2001 12:44 pm

You probably want
order by lastname desc, firstname desc, middlename desc

chand012 · Post by **chand012** » Thu Mar 22, 2001 1:42 pm

Thanks. It would be helpful if the documentation reflected this requirement. An example on page http://www.thunderstone.com/site/texisman/node55.html specifically indicates otherwise.

--David

Post by **mark** » Thu Mar 22, 2001 1:59 pm

The documentation and example on that page are correct. And states that the default ordering is ascending. It just doesn't give an example of using descending on more that one field.

chand012 · Post by **chand012** » Thu Mar 22, 2001 2:04 pm

OK, I get it. --David