ColdFusion – QueryOfQueryes and union select from dynamic table names

	<cffunction name="test" access="remote">

			<cfset var Local = structNew()>

			<cfset struktura = structNew()>

			<cfset x = 1>
			<cfset struktura['q_#x#'] = queryNew("name")>
			<cfset queryAddRow(struktura['q_#x#'], 1)>
			<cfset querySetCell(struktura['q_#x#'], "name", 'pero')>
			<cfset queryAddRow(struktura['q_#x#'], 1)>
			<cfset querySetCell(struktura['q_#x#'], "name", 'mirko')>

			<cfset x = 2>
			<cfset struktura['q_#x#']  = queryNew("name")>
			<cfset queryAddRow(struktura['q_#x#'] , 1)>
			<cfset querySetCell(struktura['q_#x#'], "name", 'slavko')>
			<cfset queryAddRow(struktura['q_#x#'], 1)>
			<cfset querySetCell(struktura['q_#x#'], "name", 'mirko')>

			<cfquery name="q_data" dbtype="query">

			<cfset count = 0>

				<cfloop collection="#struktura#" item="key" >

					<cfset count = count+1>

					<cfif count gt 1 >

					UNION all

					</cfif>

					SELECT * FROM struktura.#key#

				</cfloop>

			</cfquery>

			<cfdump var="#q_data#">

		</cffunction>
This entry was posted on Thursday, January 17th, 2019 at 1:52 pmand is filed under Coldfusion. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.