Hi,
I am sure this is a
simple one, but it has me stumped and I have too much to do.
I have a query that
returns values based on a list,
<cfquery.....>
select
*
from
mytable
where mytable_ID IN
('1','2','3')
</cfquery>
How do I get the
output to be displayed in the order that the where list went in? If I run the
query it pulls the records out in the order they are entered in the database,
but if I change the where list to ('2','3','1') is still returns in the 1 2 3
order.
Is this even
possible within the query. I have a workaround using a tag that loops through
each, but this is an awful solution and will not work within one section of the
site.
Using CFMX on a
Win2K server with SQL2000.
Thanks in advanced
to any help.
Blake
Foss
-----------------------------------------------------------------------------------
Blake Foss
Web Foot Forward
p: 61 2 9340 4401
f: 61 2 8080 8190
m: 0410 747 620
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
