Probably, though you can easily verify it yourself.
One option is using a UNION. Either in a QoQ (or your original database query).
Assign a static sort value to each statement. Then ORDER BY that value to
produce the desired ordering.
SELECT 0 AS SortValue, 'Some Value' ColumnA, 'Some Value' ColumnB
UNION
SELECT 1 AS SortValue, ColumnA, ColumnB
FROM yourQueryName
ORDER BY SortValue
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:335911
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
