> > Can You have nested <Cfloops>
> Yes, but not through 2 queries (i think)
The problem isn't that you can't loop through queries with nested loops,
but that CF can't "see" the current record of outer loops from inner
loops
As long as you store the currentRow from the outer loop before entering
the inner loop, it works fine;
<cfloop query="Query1">
<cfoutput>#Field#<br></cfoutput>
<cfset Q1Row=CurrentRow>
<cfloop query="Query2">
<cfif Field2 is Query1.Field[Q1Row]>
<cfoutput>The Same<br></cfoutput>
</cfif>
</cfloop>
</cfloop>
Hope that gives a little insight into how to get around the problem
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk
www.aspevents.net
An ISO9001 registered company.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
