October 3rd, 2011, 03:51 PM
get value of query object using conctenation
Hi guys ,
Iam trying to make the following statment more generic but it gives me "String values instead the real value" my code is below :
<cfset i = 7/>
cfset col1 = "qSheetData." & "column" & #i#/>
<cfset strMonth = #col1#/>
This gives me strMonth as string "qSheetData.column7" and not as a value.
if i replace by <cfset strMonth = qSheetData.column7/> ,
this will work..and give me my query data
Can any body tells me how should i get the data using the 1st statment ?
October 4th, 2011, 04:27 PM
As you have seen, that code just concatenates a bunch of strings to produce a bigger string. It does not evaluate anything other than the variable "i".
To access a query column dynamically, you need to use array notation. Since you are looping through a query, you can use cfquery's currentRow variable as the rowNumber
<cfset value = queryName["columnName"& i][rowNumber]>
October 4th, 2011, 04:49 PM
cfSearching is right. You're not using the structure syntax to build up the column reference.