[thelist] ColdFusion/SQL - treat as Number

[Seth Bienek]

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