Some say that usinf the tag is better, but from my own exp, using cfquery has been alot better for me.
 
The only time that I use the tag is when I am using a proc that returns multiple recordsets. Other than
that I use cfquery.
 
Clint
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian Bessemer
Sent: Monday, April 29, 2002 4:17 PM
To: [EMAIL PROTECTED]
Subject: stored procs

Does anyone know if either of these methods for calling a stored proc is faster or better than the other?

<cfstoredproc datasource="blahblah" procedure="blahblah">
    <cfprocparam blahblah>
    <cfprocparam blahblah>
</cfstoredproc>

<cfquery datasource="blahblah">
    EXECUTE blahblah #blah#, #blah#
</cfquery>

Reply via email to