Hi guys ,

I am 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#/>
<cflop query="qSheetData">
<cfset strMonth = #col1#/>
</cfloop>

this gives me strMonth as string "qSheetData.column7" and not as a value. if i replace by <cfset strMonth = qSheetData.column7/> , t
his will work..and give me my query data

Can any body tells me how should i get the data using the 1st statment ?

thanks