When you insert/update character strings in a database the string is single
quoted:
INSERT INTO myTable(myField1, myField2)
VALUES (intValue, 'chrValue')
-----Original Message-----
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 3:27 PM
To: CF-Talk
Subject: double quotes
I have a text box. When the user hits submit the data is either inserted
into the database or updates it. When I input in a double quote, the insert
and update fail.
I know there is a perservesinglequotes function. IS there something for a
double quote or do I have to parse through the whole text?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
