Been a while since I've had the 'pleasure' of writing asp but here is what I
did on an old project. You need to just escape the ' with ''
JobDescription = replace(Trim(request.form("JobDescription")), "'", "''")
It just escapes the single quote with double single quotes. JobDescription
goes into the database with no problems after that
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 4:25 PM
To: CF-Talk
Subject: OT- Escaping a single quote
I have a text field that contains that could pass single quote. Well it is
bombing the insert logic into the database. This is in asp.net which I am
new too though I primarily use CF exclusively. I have been looking around
searching for this and I am not searching correctly cause I am not finding
anything. Can some one point me in the right direction.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206577
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
