ms access - Accessing protected mysql names via ASP -


currently, i've been assisting convert site using classic asp, using ms access mysql(mainly bridge until time complete rebuild). current table uses various protected keywords column names(datetime, date, order, etc). i'm trying figure out proper ways few inserts on these columns. current code below:

set orsess = server.createobject("adodb.recordset")          orsess.addnew         orsess.fields("order") = cint(xyz)         orsess.fields("sessionid")         orsess.update 

now normally, i'd try replace standard sql insert, there's lots of code around, breaks easily. there away add proper escape character mysql recognize properly?


Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -