You don't say what the error is. You may wish to give more information. However, the problem is almost certainly caused by the use of single quotes around text in constructed strings, such as SQL statements.
How you deal with this will depend on the specific circumstances. For instance, for SQL, you will need to double any single quotes in your actual data. In JavaScript or ASP JScript, you'd use the string replace method. If you're using ASP VBScript, I assume there is a similar facility. Note that using double quotes around text in constructed strings instead of single quotes will alleviate the problem when single quotes are entered, but will of course surface if double quotes are entered. You're better off doing the replace to eliminate the problem completely. I am not aware of any HTML tag for single quote. Double quote is ", and there are tags for the special left and right quotes commonly used by word processors: ‘ and ’. I don't know how universally acceptable the left/right quotes would be. Doesn't really matter, anyway - if you're going to convert quotes to tags, you might as will just double them (or whatever else is needed by the statement giving trouble). Dave S PS don't get "double quotes" and doubling quotes confused. The first is the single " character; the second is the replacement of one ' by two consecutive ' using a transformation algorithm. ----- Original Message ----- From: Christ To: [EMAIL PROTECTED] Sent: Thursday, August 19, 2004 10:28 AM Subject: [ASP] Error posting character ' Anyone know why if we post content containing character ' generate error ? How to encounter this ? What is the HTML tag for ' ? Any others character generate error same like ' ? Thanks all Krish --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/04 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- 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/
