Not sure if I follow this. Could you expound on the [] [] plays on the results?
Thanks, Neil ----- Original Message ----- From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 5:23 PM Subject: Re: Querying Dynamic Names > 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 > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
