make the list in the order you want the records to come out in?
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 12:20 PM Subject: [ cf-dev ] order by > say you've got a query like: > > <cfquery> > SELECT ID, Name > FROM Table > WHERE ID IN (#IDList#) > </cfquery> > > where IDList maybe looks like 1,7,2,8,3,6,55,4, etc. How do you get the > query to order by the order specified in your list? Using an access > database, I've got a query like this, but it seems to be ordering by ID by > default, i.e. the order the records are stored in the table. Any simple > ways to not make this happen, like > ORDER BY #IDList# ? > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
