Append two or more query result -CFC
Hi all,
How will i append one and/ or two and/ or three query result in a cfc? I will pass variable which may contain list ={datasourceName1,datasourceName2,datasourceName3}
I am using SQL 2005...All 3 db has same table names...cfargument param is a list which may contain datasourceName1 and/ or datasourceName2 and/ or datasourceName3
Currently I have ...
<cfcomponent>
<cffunction>
<cfquery datasource='datasourceName1' name='q1'>
select * from location
</cfquery>
<cfreturn q1>
<cfquery datasource='datasourceName2' name='q2>
select * from location
</cfquery>
<cfreturn q2>
<cfquery datasource='datasourceName3' name='q3>
select * from location
</cfquery>
<cfreturn q3>
</cffunction>
