Am trying to teach myself a bit of Python by creating a small app to track tasks, and docs associated with the task. I'm using Python 2.4 on Win32 with an Access 2003 db which I'm attempting to talk to using mxODBC. I can do Selects without difficulty but a simple Insert has me stumped for days. I suspect that I am doing something silly, but I can't see it. Searching the list has shown others with similar problems but trying them did not yield anything. As an aside, why does [Date] have to have [] around it? I get a syntax error from the driver if I don't put them in?
My code exits without an error, but doesn't insert anything:
def AddFiles(self, path, files):
atime = now()
thedate = str(atime.month) + "/" + str(atime.day) + "/" + str( atime.year)
for thefile in files:
query_string = "Insert into file (ProjectID, [Date], Filename, Path) Values (?,?,?,?)"
values = (self.projectid,thedate,thefile,path)
ExecuteQuery(query_string, values)
def ExecuteQuery (qrystring, values):
myconn = connect_db()
mycursor = myconn.cursor()
mycursor.execute(qrystring, values)
myconn.close()
return
def connect_db ():
myconn = mx.ODBC.Windows.Connect('trackingdb') #using mx.ODBC
return myconn
Any help/pointers would be appreciated!
Thanks,
Bill
-- http://mail.python.org/mailman/listinfo/python-list
