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
