<cfquery
name="GetParks" datasource="cfdocexamples"
cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
SELECT PARKNAME, REGION, STATE
FROM Parks
Where REGION = 'Southeast Region'
ORDER BY ParkName, State
</cfquery>
<cfset temp = querysetcell(GetParks, "PARKNAME", " ", 1)>
<cfset temp = querysetcell(GetParks, "REGION", " ", 1)>
<cfset temp = querysetcell(GetParks, "STATE", " ", 1)>
>hi
>
>i have a query which has sort criteria applied at mysql level.
>
>i want to add a row at the top of the query after mysql has finished with it.
>
>If i use the queryaddrow method it adds the row to the bottom of the query
>
>is there anyway to get it to add it as the first item?
>
>thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:335908
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
