The quick difference between the <Cfquery> and <cfStoreproc> is you can deal
with multiple recordset returned from the stored procedure which was not
possible using <cfquery> .With <CfstoredProc> you can deal with the return
values from the stored procedures.
The Only drawback I see using <cfStoredProc> is it can not handle the varbinary
data which is possible with <cfquery>
Thanks,
Ninad
>I was just wondering if any one knew the difference between the
>following:
>
><CFSTOREDPROC PROCEDURE="usp_myproc" DATASOURCE="mydatasource">
> <CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
>dbVarName = @param2>
> <CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_INTERGER VARIABLE =
>BAR dbVarName = @param3>
></CFSTOREDPROC>
>
>AND THIS:
>
><CFQUERY Name="qryMyQuery" DATASOURCE="mydatasource">
> {CALL usp_myproc("01/23/1971", "31")}
></CFQUERY>
>
>Also, when the stored procedure returns a query, how would you access it
>through the first method? The second method at least allows you to name
>the query so that you can access the resulting recordset.
>
>Thanks,
>
>Steve Durette
>Database Administrator/Web Developer
>Engineering/Construction System Support
>SBC/Ameritech
>
>
>______________________________________________________________________
>Why Share?
> Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
> Instant Activation · $99/Month · Free Setup
> http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256632
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
