[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
------------------------------
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