Well, depending on how you are using your data, I have used URLEncodedFormat
and URLDecode in the past to store full SQL query strings in a database.
This works well but requires you to know that your data is in that format.
Not sure on Access, but you can usually escape single quotes inside a query
string with no problems. In Oracle, if you put two single quotes together,
it will insert escape the single quote, for example:
INSERT INTO dbadm2.TEMP_ESC
VALUES ('test '' this');
SELECT * from dbadm2.temp_esc;
Returns: test ' this
Eddie McReynolds
Architecture Software Analyst
Clinical Reference Laboratory
Voice: (913) 693-2512
(800) 445-6917 Ext.: 2512
Fax: (913) 492-4316
Email: [EMAIL PROTECTED]
OUR VALUES & CULTURE
* Service to Humanity * Flexibility * Commitment * Compassion * Teamwork *
* Perseverance * Quality * Integrity * Client Focus *
-----Original Message-----
From: Kristi J. Bohling [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 12:07 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] single quotes in text answers
We have a text entry area where users can enter a short answer. They are
including single quotes in their answer. This is causing an issue when
trying to submit this data to the database... it is hitting the single
quote, and is acting as if this is the end of the text string to be entered.
Anyone have a quick fix or a function that I missed? Kristi
=========================================================
Kansas City ColdFusion User Group's website & listserv is
hosted through the generous support of Clickdoug.com
To send email to the list, email [EMAIL PROTECTED]
To (un)subscribe, email [EMAIL PROTECTED] with your request.
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1.
======================================================
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
=========================================================
Kansas City ColdFusion User Group's website & listserv is
hosted through the generous support of Clickdoug.com
To send email to the list, email [EMAIL PROTECTED]
To (un)subscribe, email [EMAIL PROTECTED] with your request.
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1.
======================================================
