[thelist] ColdFusion/SQL - treat as Number

[Judah McAuley]

Looks like you want: PreserveSingleQuotes(variable)

Judah

At 05:09 PM 5/8/01 -0700, you wrote:
>Hi,
>
>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
>Know');
>
>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.
>
>Jon.
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Auctions - buy the things you want at great prices
>http://auctions.yahoo.com/
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !