PHP and ODBC querying

[jammer1221]

Hey all,

I've been working on this problem for a while and I finally figured out the exact problem.

I was having trouble updating a record from an access database (using ODBC to connect to it). it gave me not enough parameters (Error 071001).

I finally figured out that it was because some of my column names are I guess reserved keywords to the sql language (I'm not 100% sure about that).

Well my question is how I work around that? One I'm sure I have a problem with is pre. I have a column named pre and everytime I use a query with pre in it it gives the error. Whenever I don't, of course there is no error. I have no option to change the names of the Columns.

Thanks for ANY help anyone can give me. Even just a brainstorm will be helpful.

Thanks,

Matt

 

[jammer1221]

Hey guys, lol, I figured it out. It turns out it didn't have anything to do with what I thought it was. But I finally figured it out, and it all works now.