----- Original Message -----
Sent: Friday, February 07, 2003 10:41
AM
Subject: [cfaussie] Sort order from query
return
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/
---