Of course......here's an example of how to can an SP using CF.......
<CFSTOREDPROC Procedure="<proc name>" DATASOURCE="<datasource>"
RETURNCODE="Yes">
<CFPROCPARAM TYPE="In" DBVARNAME="<dbvarname1>" CFSQLTYPE="<data type1>"
VALUE="<value1>">
<CFPROCPARAM TYPE="In" DBVARNAME="<dbvarname2>" CFSQLTYPE="<data type1>"
VALUE="<value2>">
<CFPROCRESULT name="results">
</CFSTOREDPROC>
<cfoutput query="results">.
...
...
</cfoutput>
You can also pass get the SP to pass back output params aswell as multiple
resultsets.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 13:04
To: CF-Talk
Subject: Re: CFSToredProcedures
Can I still pass params to it?
----- Original Message -----
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 12:26 PM
Subject: RE: CFSToredProcedures
> The CFStoredProc tag allows you to call stored procedues on the server.
> Stored Procedures are essentially queries that are stored on the server
(as
> opposed to queries thrown at the server using cfquery). This means the
> following:
>
> 1) Stored Procedures are much faster because a query plan for the SQL you
> are running is created - i.e. the server doe not have to parse the SQL to
> ensure it is syntactically correct.
>
> 2) They are more secure - because they are database objects you are able
to
> assign permissions to them.
>
> it also means the following
>
> 3) They are not standard through ODBC - i.e. you can not port the sql
> easilly across platforms as you could if you had written ANSI standard SQL
> in a CFQuery.
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> ------------------------------------------------------------------
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -----Original Message-----
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 17 May 2001 12:19
> To: CF-Talk
> Subject: CFSToredProcedures
>
>
> This is from CF Studio Documnetation:
>
> "Stored procedures represent an advanced feature, found in high-end
database
> management systems. You should be familiar with stored procedures and
their
> usage before implementing these tags."
>
> I'm not familier with that CF TAG but I know alot of people use it, is it
> faster then CFQUERY?
> what is the advantage of using it? can I specify several CFQUERIES with
it?
>
> Thanks,
>
> Michael Lugassy
> IT/WEB Specialist
> Interactive Music Ltd.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
