You can refer to this link to appendQuery
http://www.bennadel.com/blog/114-ColdFusion-QueryAppend-qOne-qTwo-.htm
I guess you should go with method one as of my understanding. Posting example
here.
appendQuery.cfm
<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 testQuery = queryNew("PARKNAME,REGION,STATE","varchar,varchar,varchar")>
<cfset queryAddrow(testQuery,1)>
<cfset test1 = createObject('component','appendQuery')>
<cfset resultQuery = test1.QueryAppend(testQuery,GetParks)>
<cfdump var="#resultQuery#">
<cfabort>
<cfset test1 = createObject('component','appendQuery')>
<cfset resultQuery = test1.QueryAppend2(testQuery,GetParks)>
<cfdump var="#resultQuery#">
appendQuery.cfc
<cffunction name="QueryAppend" access="public" returntype="query" output="false"
hint="This takes two queries and appends the second one to the first one.
Returns the resultant third query.">
<!--- Define arguments. --->
<cfargument name="QueryOne" type="query" required="true" />
<cfargument name="QueryTwo" type="query" required="true" />
<cfargument name="UnionAll" type="boolean" required="false" default="true" />
<!--- Define the local scope. --->
<cfset var LOCAL = StructNew() />
<!--- Append the second to the first. Do this by unioning the two queries. --->
<cfquery name="LOCAL.NewQuery" dbtype="query">
<!--- Select all from the first query. --->
(
SELECT
*
FROM
ARGUMENTS.QueryOne
)
<!--- Union the two queries together. --->
UNION
<!---
Check to see if we are going to care about duplicates. If we don't
expect duplicates then just union all.
--->
<cfif ARGUMENTS.UnionAll>
ALL
</cfif>
<!--- Select all from the second query. --->
(
SELECT
*
FROM
ARGUMENTS.QueryTwo
)
</cfquery>
<!--- Return the new query. --->
<cfreturn LOCAL.NewQuery />
</cffunction>
>> 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?
>
>You could add the new row in the SQL itself using a UNION statement,
>couldn't you?
>
>Otherwise, you could add it using queryAddRow, querySetCell, etc, but
>you'd have to figure out how to get things in the order that you want
>them. You could create a new query, add the row to the new query, then
>loop through the old query and add each row to the new query. Or you
>could use queryAddRow and querySetCell with the existing query, but
>have a sortable field for all rows including the new row, then use
>query of query to sort the query again.
>
>But I'd go with doing this in your SQL if I were you.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>http://training.figleaf.com/
>
>Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
>GSA Schedule, and provides the highest caliber vendor-authorized
>instruction at our training centers, online, or onsite.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:335913
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
