err... that's an "isn't practical" G 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/
