Its OK I worked it out
<cfstoredproc procedure="ap_MBR_inspect" datasource="#application.ds#">
<cfprocparam value="gb17" cfsqltype="cf_sql_varchar">
<cfprocparam value="07-jul-2007" cfsqltype="cf_sql_date">
<cfprocresult name="qryReport" resultset="1">
<cfprocresult name="qryData" resultset="2">
<cfprocresult name="qryDetail" resultset="3">
</cfstoredproc>
<cfdump var="#qryReport#">
<cfdump var="#qryData#">
<cfdump var="#qryDetail#">
Brian Knott
ext 61984
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT,
Brian
Sent: Wednesday, 25 June 2008 8:47 AM
To: [email protected]
Subject: [cfaussie] Multiply Queries
Can a cfstoredproc return multiply queries.
I have a stored proc that returns 2 or 3 queries. When I use cfstoredproc it
only returns the first query. Is there any way to return all queries or do I
have to break the stored procedure in to separate stored procs that only return
1 query each.
Thanks
Brian Knott
MIS Specialist | Pricing and MIS CFO Banking | CFO Retail Banking
ext 61984 ph 07 3836 1984 fax 07 3835 5455
________________________________
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its
related entities "Suncorp".
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11
55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does
not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the intended
recipient. If you are not the intended recipient, any use, interference with,
disclosure or copying of this e-mail, including attachments, is unauthorised
and expressly prohibited. If you have received this e-mail in error please
contact the sender immediately and delete the e-mail and any attachments from
your system.
If this e-mail constitutes a commercial message of a type that you no longer
wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
