Wrong Wrong Wrong!!! the main limitation with using cfquery to run a sp is that you can only use one result set in a cfquery - whereas you can access more than one using CFSTOREDPROC.
The only problems I have ever had with cfstoredproc, are that you seem to need to declare all the params in the same order as in sql server. I would always use cfstoredproc HTH Dan -----Original Message----- From: Colin Robinson [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 14:20 To: SQL Subject: RE: Running SP's from cfquery Eric, Thank you for the response , that is what I had suspected. That withstanding in your experience would you say that CFSTOREDPROC is flaky and should be avoided if possible ? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 13 November 2001 12:46 > To: SQL > Subject: Re: Running SP's from cfquery > > > You can't. You have to use CFSTOREDPROC for that. > |-----------------------+------------------------------------- > ------------| > |Eric A. Laney |Yesterday is a memory. Tomorrow is a > vision. | > |Systems Engineer |Today is a bitch. > | > |LAN Optimization Team | > | > |Verizon Data Services | > | > |Voice: 813.978.4404 | > Today's Fortune| > |Pager: 888.985.8519 | > | > |-----------------------+------------------------------------- > ------------| > > > > > > > > "Colin Robinson" > > <colin.robinson@in-tuit To: > SQL <[EMAIL PROTECTED]> > ion.co.uk> cc: > > Subject: > Running SP's from cfquery > 2001-11-13 07:09 > > Please respond to sql > > > > > > > > > > How do you indicate when using cfquery to execute a stored proc which > results set you require? > > Colin Robinson > Senior Analyst Programmer > In-tuiton.co.uk > +44 1825 746400 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
