You do not have to use CFSTOREDPROC as long as you notate your arguments
correctly. <cfquery> {call sp_whatever(var1, var2, varoutput)}</cfquery>
in your stored procedure set up varoutput to be on out varible and set you
selected output that you want to get back to that varible and return that
varible in your SP. Although I will say that I agree with an earlier post
that as long as you list your vars in the same order with cfstoredparam that
they are listed in your SP, that there is not an issue with using
cfstoreproc. I use both and never had a problem with either.
Thank you,
Christian Watt
Webmaster
SkillPath Seminars
[EMAIL PROTECTED]
-----Original Message-----
From: Max Kington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 9:21 AM
To: SQL
Subject: Re: Running SP's from cfquery
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
