HELP!!! the problem of handling special character
I use a "INSERT INTO" instruction to add new record, the value of one field is HTML code that having quotation mark and comma ,
i get this error when submit:
²»ÃòÃÃ÷£¬ÃµÃ³±¨ÃçÃôÃÃó£ º
Microsoft JET Database Engine ´ÃÃó '80040e14'
Ãï·¨´ÃÃó (²ÃÃ÷·û¶ªÃ§) Ãòéï±Ã´ïý ''openBrWindow('Store_detail.asp?InfoID=1','detail ','scrollbars=auto' Ãá£
it seen that the html code has damaged the SQL statement.
How to solve that problem if i must use the html data??
|