Charlie Griefer wrote:
> case statement in the ORDER BY should work.
>
> See http://www.devx.com/tips/Tip/17288
Checking my syntax, but doesn't seem to work for a query of queries..
Like:
<cfloop query="featureMENU">
<cfset temp = QueryAddRow(hasMEDIA)>
<cfset temp = QuerySetCell(hasMEDIA, "tHEAD", "#req.tHEAD#", #tCOUNT#)>
<cfset temp = QuerySetCell(hasMEDIA, "sid", "#sid#", #tCOUNT#)>
</cfloop>
<cfquery dbtype="query" name="getAllMedia">
SELECT
tHEAD,
sid
FROM hasMEDIA
ORDER by ( Case thisHEAD
WHEN 'Feature Article' THEN 1
WHEN 'Quoatable' THEN 2
WHEN 'On the Money' THEN 3
WHEN 'In the News' THEN 4
WHEN 'Innovation' THEN 5
WHEN 'About Us' THEN 6
WHEN 'Border Bound' THEN 7
WHEN 'Quick Facts' THEN 8
ELSE 100 END )
</cfquery>
ERROR: Query Of Queries syntax error.
Encountered "(. Incorrect ORDER BY column reference [(].
Only simple column reference, alias name, and integer column id are
allowed.
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5115 (20100514) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
