Hey,

I'm trying to store a textarea that people can type whatever to a db... it works fine so long as no apostrophes are typed... or if they are typed, you need to put 2 in a row.... Is there any way that I can fixe this, wether it be in the sql statement or otherwise...

query = "INSERT INTO test "
query = query & "(notes) VALUES "
query = query & "('"&Request.Form("notes")&"')"

Use Replace function to replace single quotes /apostrophes with two single quotes.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Before building the qurery do this ...

strNotes = Request.Form("notes")
If Len(trim(strNotes )) > 0 then
strNotes = Replace(strNotes ,"'","''")
End if

Inside the query use strNotes now. Btw i haven't tested it .. i am just typing it from top of my mind. The logic is surely right .. but just check for any syntax errors :)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Thank you