Problem with strings in SQL statement
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7294
Printed Date: 31 March 2026 at 3:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem with strings in SQL statement
Posted By: FLATLINE
Subject: Problem with strings in SQL statement
Date Posted: 15 November 2003 at 7:20am
|
I have a problem when I want to parce a string to a SQL statement, but the string containst a ' character (single quote), and that screws up the whole code... I could try and use the Replace() function to replace the ' with an ASCII code, but then it wouldn't find the records that I need... Can anyone help? ------------- Visit my site: http://darkgreen.service-club.net - DarkGreen HQ 
|
Replies:
Posted By: MorningZ
Date Posted: 15 November 2003 at 9:45am
|
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=27 - http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=27 ------------- Contribute to the working anarchy we fondly call the Internet |