RE: Returning 2 queries from stored proc
Couldn't be eaiser! Thanks. -Original Message- From: Michael Dinowitz create proc test as select * from table1 select * from table2 This stored procedure will return both to the cfstoredproc tag > How do I define the two result sets in the Stored Proc? I am using MS SQL > and I can't find anything in their help guide. > > -Original Message- > From: Michael Dinowitz > > Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each > CFPROCRESULT will have the query name and the order of it's operation from > within the stored procedure. > > > > > > > >> Is it possible to return two different queries from a single stored proc? >> >> Andy Ousterhout >> >> >> > > > ~| 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:197677 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
RE: Returning 2 queries from stored proc
Yep, just have to use cfprocresult. However there is a limit on how may you can return - I believe we tested it with 7-9 depending on the size of the resultsets. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 March 2005 01:52 To: CF-Talk Subject: Re: Returning 2 queries from stored proc create proc test as select * from table1 select * from table2 This stored procedure will return both to the cfstoredproc tag > How do I define the two result sets in the Stored Proc? I am using MS SQL > and I can't find anything in their help guide. > > -Original Message- > From: Michael Dinowitz > > Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each > CFPROCRESULT will have the query name and the order of it's operation from > within the stored procedure. > > > > > > > >> Is it possible to return two different queries from a single stored proc? >> >> Andy Ousterhout >> >> >> > > > ~| 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:197644 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
Re: Returning 2 queries from stored proc
create proc test as select * from table1 select * from table2 This stored procedure will return both to the cfstoredproc tag > How do I define the two result sets in the Stored Proc? I am using MS SQL > and I can't find anything in their help guide. > > -Original Message- > From: Michael Dinowitz > > Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each > CFPROCRESULT will have the query name and the order of it's operation from > within the stored procedure. > > > > > > > >> Is it possible to return two different queries from a single stored proc? >> >> Andy Ousterhout >> >> >> > > > ~| 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:197635 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Returning 2 queries from stored proc
> How do I define the two result sets in the Stored Proc? > I am using MS SQL and I can't find anything in their help > guide. All you have to do is have multiple SELECT statements within your stored procedure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197628 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Returning 2 queries from stored proc
How do I define the two result sets in the Stored Proc? I am using MS SQL and I can't find anything in their help guide. -Original Message- From: Michael Dinowitz Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each CFPROCRESULT will have the query name and the order of it's operation from within the stored procedure. > Is it possible to return two different queries from a single stored proc? > > Andy Ousterhout > > > ~| 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:197627 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Returning 2 queries from stored proc
Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each CFPROCRESULT will have the query name and the order of it's operation from within the stored procedure. > Is it possible to return two different queries from a single stored proc? > > Andy Ousterhout > > > ~| 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:197624 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Returning 2 queries from stored proc
On Sun, 6 Mar 2005 16:24:57 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > Is it possible to return two different queries from a single stored proc? Yes. http://livedocs.macromedia.com/coldfusion/7/htmldocs/0314.htm -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 49, yes 49, invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197622 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54