How Can I make TextArea take Apostrophes

[Guest_imported]

Yikes,,

My TextArea box on my form will dump every time you enter an Apostrophe.

I found a fix,but now it will not even update the filed in the database: Here is the fix, can you tell what is wrong?

strsqlT = "INSERT INTO HRForm (Duties) " & "VALUES ('" & strTextArea & "')"

strTextArea = Replace(Request.Form("S1&quot, "'", "''&quot

S1 is the name of the field for "Duties", but now the SQL statement wont' even update.

Any Ideas?
Thanks,
Tuleta

 

[khorjak]

Just an idea...maybe you should replace strTextArea before sticking it into strsqlT.

Choo Khor
choo.khor@intelebill.com