query1[query2.field] is incorrect

[dobaldwin]

I'm trying to reference one query by the output of another. For example:

The output of query1.field is "first_name"

I want to somehow use this output of "query1.field" and use it in a reference,
like so:

query2."query1.field"
--or--
query2.first_name

I tried looking in documentation, etc, but I can't find any help on this
topic. I can do something similar with forms: FORM[query1.field] (which I
learned on macromedia forums), but can't seem to find a way to do it between
queries.

Am I asking too much? Is there another approach to this?

Please help.

[mxstu]

When using array notation for queries, you need to specify the query row number: query[columnname][rownumber]

<cfoutput query="query2">
#query2[query1.Field][currentRow]#<br>
</cfoutput>

[dobaldwin]

Hm... still trying to get it to work correctly. This is what I have:

<cfloop query="query1">
#query1.field1#
<cfloop query="query2">
#query2[query1.Field][currentRow]#<br>
</cfloop>
</cfloop>

Isn't there anything like Javascript's Evaluate() function?

Again, thanks for the help!

[dobaldwin]

I'm an idiot. My last post answered my own question. There is an Evaluate
function in ColdFusion. Here it is in action:

<cfloop query="query1">
#query1.field1#
#Evaluate("query2.#query1.field#")#
</cfloop>

Thanks everybody for putting up with me while I thought this one through.

[mxstu]

Originally posted by: dobaldwin
There is an Evaluate function in ColdFusion ....


Yes, Evaluate() does work, but is not necessary here to get the job done. Try
and avoid using Evaluate() unless it is absolutely necessary, as it requires
more processing than a straight output. I'm not certain what information you
are trying to output, but if you are only need to output the first row in
"query2", the attached does the same thing without using Evaluate().



<cfoutput query="query1">
#query1.field#<br>
#query2[query1.Field][1]#<br>
</cfoutput>