[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