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]
