there's also nothing stopping you from using cfquery, to be honest, I've never used CFSTOREDPROC, I'm guessing this is supposed to provide some more abstraction from the database, so that if you used oracle's native drivers it would still work. <cfquery> exec myStoredProc @args </cfquery> if it's Sybase or MS SQL ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 2:46 PM Subject: RE: Running SP's from cfquery
> I have no idea where that idea came from, though I hear it all the time. I > use CFSTOREDPROC all the time with no problems. I've had a couple of > people tell me that they had problems until they set their PROCPARAM > statements in the same order as the definition of the stored procedure. > However, I do that all the time anyway, and it's probably a good idea > regardless. > |--------------------------------+----------------------------------------| > |Eric A. Laney |Ask a silly person, get a silly answer | > |Systems Engineer | | > |LAN Optimization Team | | > |Verizon Data Services | | > |Voice: 813.978.4404 | | > |Pager: 888.985.8519 | | > |--------------------------------+----------------------------------------| > > > > > > > "Colin Robinson" > <colin.robinson@in-tuit To: SQL <[EMAIL PROTECTED]> > ion.co.uk> cc: > Subject: RE: Running SP's from cfquery > 2001-11-13 09:20 > Please respond to sql > > > > > > > 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
