Page 1 of 1

ASP/Vbscript Escape Function for AccessDB

Posted: Fri Dec 08, 2006 7:32 pm
by trent2800
I'm doing a small project for work and the only combo that I can use is ASP/VBscript with an Access DB(ewww). The only thing that I cant figure out is how to escape inputs so I can put special characters into the db. Any assistance on this would be appreciated. Thanks, Tyler

Posted: Sat Dec 09, 2006 1:48 am
by volka
Do you use adodb and something like

Code: Select all

recset.AddNew
recset("field1") = "yaddayadda"
recset("field2") = Request.Form("xyz")
recset.Update
?
Then escaping, encoding, ... is done by ADODB.Recordset object recset.

Posted: Sat Dec 09, 2006 4:23 am
by trent2800
I dont, but I will now!