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
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
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
3 matches
Mail list logo