> procedure. I thought they are tags that compliemnt each other
> (either or).
You can invoke stored procedures using CFQUERY with some database servers,
such as SQL Server. Typically, you can do this by invoking a stored
procedure using either ODBC call syntax or the same syntax you'd use to
invoke a stored procedure from an SQL batch. Here's an example of ODBC call
syntax:
<cfquery ...>
{ call mysp(#mynumericparam#, '#mytextparam#') }
</cfquery>
The advantages of doing this instead of using the CFSTOREDPROC tag are that
you can cache recordsets using CACHEDWITHIN/CACHEDAFTER, and that you can
write it a little more easily in some cases.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
