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
