ahh, cheers, noted ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 3:10 PM Subject: Re: Running SP's from cfquery
> That is true, but the original question was on how to use CFQUERY to choose > a particular recordset when your stored procedure returns more than one. > In that situation, you have to use CFSTOREDPROC instead of CFQUERY. > |-------------------------+-----------------------------------------------| > |Eric A. Laney |It is easier to resist at the beginning than at| > |Systems Engineer |the end. | > |LAN Optimization Team | | > |Verizon Data Services | | > |Voice: 813.978.4404 | Today's Fortune| > |Pager: 888.985.8519 | | > |-------------------------+-----------------------------------------------| > > > > > > > > "Max Kington" > <max@webhange To: SQL <[EMAIL PROTECTED]> > r.com> cc: > Subject: Re: Running SP's from cfquery > 2001-11-13 > 10:05 > Please > respond to > sql > > > > > > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
