I think I will test the performance diff's and see if I can get some idea
what the best practice might be for this.
-Original Message-
From: Daryl Banttari [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Prepared statements
Whoops accidentally hit Send...
Anyhoo...
Either way you get the query-plan-caching benefit of cfqueryparam. Since
the SQL Server ODBC driver has that option checked by default, I generally
leave it alone.
Daryl
- Original Message -
From: Daryl Banttari [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 10:29 AM
Subject: Re: [KCFusion] Prepared statements
I believe the checkbox is use stored procedure for prepared statement or
something along that line. If you check it, then the SQL Server ODBC
driver
will use sp_executeSQL whenever the use of CFQUERYPARAM would normally
create a regular preparedStatement.
From SQL2000 books online:
---
sp_executesql
Executes a Transact-SQL statement or batch that can be reused many times,
or
that has been built dynamically. The Transact-SQL statement or batch can
contain embedded parameters.
- Original Message -
From: Bryan LaPlante [EMAIL PROTECTED]
To: KCFusion [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 9:21 PM
Subject: [KCFusion] Prepared statements
I have two questions. When you set up a dsn in the CF there is a check
box
that says Create stored procedures for prepared statements. Do I need
to
check that box to get cfquery's to work that include cfqueryparam's?
Second
question, if it does create a stored proc for my query would I just
continue
to run the query with the cfqueryparam or would I need to run it as a
stored
procedure?
Bryan LaPlante
President
Network Web Applications Inc.
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]