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
