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
Post a Comment