Records set in CFStruct

2009-08-12 Thread Matthew Allen
Can someone please point me to the right direction. I am returning two result sets from a single query (stored proc). When I CFDUMP query as in cfdump var=#returnStruct# i get the two record sets displayed below. The question is how do I use cfoutput to display the record set below; Thanks

RE: Records set in CFStruct

2009-08-12 Thread Adrian Lynch
, but this is one that'll work. Adrian -Original Message- From: Matthew Allen [mailto:a.matthe...@yahoo.com] Sent: 12 August 2009 12:21 To: cf-talk Subject: Records set in CFStruct Can someone please point me to the right direction. I am returning two result sets from a single query

Re: Records set in CFStruct

2009-08-12 Thread Matthew Allen
Thanks Adrian works like a charm... cfset bothQueries = fnc_navigation(args go here) cfset thisIsOneQuery = bothQueries.rs_navsFrontEnd cfset thisIsTheOtherQuery = bothQueries.rs_navsAdmin cfdump var=#thisIsOneQuery# cfdump var=#thisIsTheOtherQuery# cfoutput query=thisIsOneQuery ...