[thelist] ColdFusion/SQL - treat as Number

Seth Bienek seth at sethbienek.com
Tue May 8 19:15:02 CDT 2001

> I am using ColdFusion and Access and if a field has a "'"
> (apostrophe) in it, CF throws an error on the SQL.

Hi John,

You'll want to use the Replace() function to escape those apostrophes with doubles:

Replace(Form.Foo, "'", "''", "ALL")

Take Care,


Seth Bienek
Solutions Development Manager
Stonebridge Technologies, Inc.
972.455.7294 tel
972.404.9754 fax
ICQ #7673959

More information about the thelist mailing list