Thanks, I just realised that before I posted again, God alone knows what I thought I was trying to do with it earlier! The 17 recordsets are all returned via one stored procedure call within the CFC so there really is only DB call, couldn't do it any other way as the data that is returned is keyed on a position on screen so I have to get all top row, middle row, etc data.
>Reference each query through the structure perhaps? > >Does this work? ><cfoutput query="structurename.RS1"> ></cfoutput> > ><cfoutput query="structurename.RS2"> ></cfoutput> > >But this begs the question, why are there 17 recordsets? Might a single >query do the job? > >Matthew Small >Web Developer >American City Business Journals >704-973-1045 >[EMAIL PROTECTED] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
