My understanding is that you can only run through one query at a time (with CF
handling the currentRow your on.)
So you are going to want to only rely on the query= for one of your two loops. Or
maybe none.
This is not the only way, but it should work.
Other people will chime in with the correct (and faster) ways, but this should get you
going.
<cfoutput>
<cfloop index="cRow" from="1" to="#SecondQuery.recordCount#" step="1">
#SecondQuery['RowName'][cRow]#
<cfloop index="cRow2" from="1" to="#first.recordCount#" step="1">
#SecondQuery['RowName'][cRow]#
#first['RowName'][cRow2]#
</cfloop>
</cfoutput>
Jerry Johnson
>>> [EMAIL PROTECTED] 04/08/02 05:09PM >>>
I have a problem:
I query a database to get a list of items (apple, orange, grape)
Then I query another database using those values.
Select
<Cfloop query="first">
Info as #RowName#
</cfloop>
.
So what I get is a value for Apple, Orange and Grape.
I then need to diaplay these values:
<cfoutput query="SecondQuery">
<cfloop query="first">
#RowName#
</cfloop>
</cfoutput>
The RowName there should be the value from the second query. If I use
SecondQuery.Rowname with evaluate I only get the First Value found in this
query.
So what do I do :)
Thanks,
Neil
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
