ASP/Vbscript Escape Function for AccessDB

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
trent2800
Forum Commoner
Posts: 48
Joined: Mon Oct 02, 2006 7:02 am

ASP/Vbscript Escape Function for AccessDB

Post 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
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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.
trent2800
Forum Commoner
Posts: 48
Joined: Mon Oct 02, 2006 7:02 am

Post by trent2800 »

I dont, but I will now!
Post Reply