> Not sure why the code didn't paste, here it is again: > <cfoutput> > <table border="1"> > <cfloop query="wine"> > <cfquery name="hotelWine" datasource="#request.dsn#"> ...
This isn't the answer to your question exactly, but why not simply rewrite the page to use one SQL query to fetch all wines and the hotels which serve them, ordered by wines, then use CFOUTPUT with the GROUP attribute to display them all in one fell swoop? This generally works a lot better than running a query, looping over said query, and running another query within the loop. It'll probably also fix your looping problem, as a side benefit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
