#Evaluate(qn)#
> I want to dynamically create a variable name based upon a url variable.
> First I set up a couple of strings:
> <CFSET qs = 'q'>
> <CFSET qn = #Insert(url.q, qs, 1)#>
>
> Where q is a number from 1-37 passed via url variable. Let's say that
> url.q is 7. Then qn is 'q7'.
> So I query the database like this:
>
> <CFQUERY NAME="get_results" DATASOURCE="datasource">
> SELECT #qn#
> FROM database
> </CFQUERY>
>
> And it correctly pulls all the results from the 'q7' column. So far so good.
> But now I want to be able to manipulate the query results and refer to the
> q7's from the database query. If I refer to #qn# I only get q7 as the
> result. So how do I have it refer to the variable q7 and not the string q7?
>
> Thanks!
>
> Jenny
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
