Dynamic variable names in QuerySetCell

2003-12-16 Thread Ryan Kime
I'm trying to avoid Evaluate and have hit a wall. I am trying to dynamically call column names from qResults and set the values in a QuerySetCell - val1, val2, val3, val4, etc... Here's an example: cfset Monthly2003= QueryNew(month, dollar_amount) cfset QueryAddRow(Monthly2003, 12) cfloop

re: Dynamic variable names in QuerySetCell

2003-12-16 Thread Scott Brady
Original Message: From: Ryan Kime [EMAIL PROTECTED] cfloop index=LoopCount from=1 to=12 cfset QuerySetCell(Monthly2003, month, curMonth, LoopCount) cfset QuerySetCell(Monthly2003, dollar_amount, qResults[valLoopCount], LoopCount) /cfloop The second QuerySetCell is what is killing me. It

RE: Dynamic variable names in QuerySetCell

2003-12-16 Thread Ryan Kime
Good question Scott, the recordcount of qResults will always be 1. FYI, adding the [1] worked! Thanks! -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 3:05 PM To: CF-Talk Subject: re: Dynamic variable names in QuerySetCell Original