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??