The CF magic trick is to use the "preservesinglequotes()" function around
your data in your SQL statement.
-----Original Message-----
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 9:20 AM
To: CF-Talk
Subject: Inserting ' and " into SQL
I have a query blowing up when I try to insert a ' or " into a text field.
What is the trick for handling this?
A replace list? or this there something better?
Justin Hansen - [EMAIL PROTECTED]
Web Application Developer
Interactive Business Solutions, Inc
816-221-5200 ext. 1305
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
