the list is already in the order i want. but the query is just returning them in the order they are stored in the table, i.e. by ID, which is screwing up my order. So I have to specify something in the Order By, or find another way to do this.
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! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Matt Horn" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> rn.org> cc: Subject: Re: [ cf-dev ] order by 29/09/2003 11:23 Please respond to dev 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] -- ** 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]
