Question about Sort/Order 2

[junkjones]

This is probably a total newbie question, but I can't seem to find the answer!

I want to generate a query and sort in decsending order. I've been using

ORDER by startdate

which does it in acsending order, but now I want to sort in the opposite direction, I found this tag:

sort="startdate DESC"

but that is from a cfdirectory tag, not a cfquery tag. What is the proper syntax to put in my query to sort in decending order?

Thanks!!
[sig][/sig]

 

[tempoman]

To junkjones,

The easiest way is to sort it descending order in your sql query.

e.g. ORDER by startdate DESC

for your above example [sig][/sig]