I have not had the luxury of CF automatically escaping single quotes at
anytime, nor does preservesinglequotes escape single quotes.
But <cfset var = Replace(var,"'","''")> works.
Jeff Sarsoun
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 11:42 PM
To: CF-Talk
Subject: Re: Small problem and banning O'Conners
On 1/25/01, Jon Hall penned:
>Use preservesinglequotes() in your insert statement.
CF automatically escapes single quotes with an extra single quote
when in SQL statements, allowing the insert to work. Using
preservesinglequotes stops CF from doing that and in an INSERT or
UPDATE will CAUSE the problem Paul is experiencing.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
