[thelist] CF query tip

Scott Brady evolt at scottbrady.net
Thu Jan 31 12:31:01 CST 2002


Judah wrote:

> There are two ways to handle this.
>
> 1) Set a variable before the <cfquery> so that the value you want to
insert
> is evaluated prior to being put in the where clause
>
> 2) Escape the string yourself manually replacing a single quote with two
> single quotes

3)  cfqueryparam should also take care of it (and it's simpler).  I haven't
had any single quote problems using cfqueryparam in SQL Server, Oracle, or
(surprisingly) Access.

Scott

----------------------------------------------
Scott Brady
http://www.scottbrady.net/





More information about the thelist mailing list