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
