Pam: You should always get an error. Curious that you don't (unless for some reason: the string has two quotes). Anyway: prior to entering the data into the database: you should do a replace on the string. sString = Replace(sString,"'","''")
HTH Andy _____ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 1:37 PM To: [email protected] Subject: [ASP] using quotes in forms Hi, I am using an online form to enter short article data into a MySql database. If I use an apostrophe or a quotation mark in the article text that I enter into the form field I will almost always (but not always) get an error message and the data does not get posted. Is there something I can do to allow quotes and apostrophes to be used in an online form? Thanks, Pam --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages <http://groups.yahoo.com/group/active-server-pages> --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- _____ YAHOO! GROUPS LINKS * Visit your group "active-server-pages <http://groups.yahoo.com/group/active-server-pages> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h1ebhcr/M=362131.6882499.7825260.1510227/D=groups/S=1705115381:TM/Y=YAHOO/EXP=1124743366/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
