Another reason to use <CFSTOREDPROC>
would be because it able to translate into an actual system level call for a
stored procedure at the ODBC/JDBC level (assuming the driver supports if) - and
not the parsing and execution of a SQL statement. So using
<CFSTOREDPROC> would be faster than using <CFQUERY> in many cases.
Much better when it comes to properly optimised code across different
DB's.
[Taco Fleur]
[Taco Fleur]
Would
<cfquery
....>
{CALL spMyStoredProc
('test')}
</cfquery>
</cfquery>
Not do the
same?
---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf |
