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
______________________________________________________________________
Dedicated Windows 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=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
