Accessing protected mysql names via ASP

66 views Asked by At

Currently, I've been assisting someone to convert a site using classic ASP, from using MS Access to MySQL(mainly as a bridge until we get time to do a complete rebuild). The current table uses various protected keywords as column names(Datetime, Date, Order, etc). I'm trying to figure out the proper ways to do a few inserts on these columns. The current code is below:

Set oRSess = Server.CreateObject("ADODB.Recordset")

        oRSess.AddNew
        oRSess.Fields("Order") = CInt(xyz)
        oRSess.Fields("SessionID")
        oRSess.Update

Now normally, I'd try to just replace this with a standard SQL insert, but there's lots of code around, that breaks easily. Is there away to add a proper escape character for MySQL to recognize it properly?

0

There are 0 answers