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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists