[thelist] ColdFusion/SQL - treat as Number

Judah McAuley judah at alphashop.com
Tue May 8 19:14:32 CDT 2001

Looks like you want: PreserveSingleQuotes(variable)


At 05:09 PM 5/8/01 -0700, you wrote:
>I need an equivalent to the php stripslashes and addslashes for
>ColdFusion. I am using ColdFusion and Access and if a field has a "'"
>(apostrophe) in it, CF throws an error on the SQL.
>For example:
>INSERT INTO table_name (field,field1,field2) VALUES (1,'Jon','Don't
>I tried replacing the outer quotes with double quotes, but it still
>gave an error. Is there another way around this?
>If you need me to explain a little more, please ask.
>Do You Yahoo!?
>Yahoo! Auctions - buy the things you want at great prices
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list