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
...
/cfoutput
There are other ways, 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 (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
struct
...SNIP...
The code.
cffunction name=fnc_navigation access=public output=NO
returntype=struct
cfargument name=DSN type=string required=yes default=
cfargument name=permission type=numeric required=yes
default=0
cfset var returnStruct = StructNew() /
cfstoredproc datasource=#arguments.DSN#
procedure=usp_navigation
cfprocparam cfsqltype=CF_SQL_INTEGER
value=#arguments.permission#
cfprocresult name=rs_navsFrontEnd resultset=1
cfprocresult name=rs_navsAdmin resultset=2
/cfstoredproc
cfset returnStruct.rs_navsFrontEnd = rs_navsFrontEnd /
cfset returnStruct.rs_navsAdmin = rs_navsAdmin /
cfreturn returnStruct /
/cffunction
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4