Textarea Apostrophe

i have a textarea in my form, and it worked. but if the input text contains apostrophe, i would get sth like this:

Microsoft OLE DB Provider for ODBC Driverserror '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''rtert'','Judy Nadia Jolonius');'. /saveRemarks.asp, line 195

how can i make asp ignore the apostrophe?

View Replies