QueryAddColumn then populate it

[noe....@gmail.com]

Hi all,

Wondering if there is a way to add a column to a query, then set the value for the current row on that column? Something like:

<cfset QueryAddColumn( queryA, #variable1# )>

<cfset QuerySetCell( queryA, #variable1#, #variable2# )>

Adding the column works just fine, but QuerySetCell doesn't seem to like a variable column name.

Thanks,
Todd

[mrjung...@gmail.com]

This seems to work (using CF11):

<cfset variable1 = "col3" />

<cfset queryA = queryNew("col1, col2", "VarChar, VarChar") />
<cfset queryAddColumn(queryA, "#variable1#", "VarChar", #arrayNew(1)#) />

<cfset queryAddRow(queryA, 1) />
<cfset querySetCell(queryA, "col1", "here", 1) />
<cfset querySetCell(queryA, "col2", "there", 1) />
<cfset querySetCell(queryA, "#variable1#", "and everywhere", 1) />

<cfdump var="#queryA#" label="" />