Peter, > I have two queries - the output of the first one is handled by a cfoutput > > tag, the second one is handled by a cfloop (nested construction): > > <cfoutput query="query1"> > bla bla #query1.name#: > <cfloop query="query2> > #query2.surname# (event: #query1.eventtitle#)<br> > </cfloop> > > </cfoutput> >
Its a long time known issue and your work around is the one that you need to use. Regards Stephen PS. There's nothing wrong with nesting your loops like this, although some would argue that having two cfloops with cfoutputs around only the bits of code your need outputing is more efficient, but this doesn't get around the issue of an inner query loop only seeing the first record of the outer query loop. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
