Dont put the order by clause in otherwise it wont dorder it properly
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of grant Sent: Tuesday, April 05, 2005 1:31 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL ordering doh! shoulda tested the code before replying... the Onnis method returns the records out of order.... dammit G On Apr 5, 2005 1:27 PM, Mark Mandel <[EMAIL PROTECTED]> wrote: > Could also build your case / iif statement dynaically as well.. prolly > faster on your DB.. > > Just a thought o_O > > Mark > > On Apr 5, 2005 1:23 PM, grant <[EMAIL PROTECTED]> wrote: > > K thanks everybody, i think i'm going to use the 'steve onnis' method: > > > > <cfloop list="127,124,121,133,122,128,125,132" index="i"> > > > > SELECT * > > FROM tbl_calls, > > WHERE call_id = #i# > > > > <cfif i NEQ listLast(list)> > > UNION > > </cfif> > > > > </cfloop> > > > > all the other solutions weren't really workable - all the ids are > > dynamically passed thru and are arbitrarily (sp?) ordered so using > > ORDER BY or manually sorting them is practical. > > > > Thanks again! > > G > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > ICQ: 3094740 > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
