Try this in your ORDER BY clause: ORDER BY catID, orderID
You shouldn't have to specify "ASC", since that is the default sort order, but it won't hurt if you do. Hope that helps, Jay Laengrich -----Original Message----- From: Robert Julian Browning [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 12:55 PM To: [EMAIL PROTECTED] Subject: ordering... i guess it is just one of those days... i have a drop menu that is powered by a CFQUERY result... what i am trying to do is make it display by catID ASC and orderID ASC... i just can't seem to make it work... here is my query... <CFQUERY NAME="GetSubCat" DATASOURCE="#REQUEST.DataSource#" CACHEDWITHIN="#CreateTimeSpan(0,1,0,0)#"> SELECT catID, orderID, subcatID, subcatName FROM SubCategories ORDER by catID ASC </CFQUERY> thx in advance... _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
