another newboe mxodbc quest. -- update set
Nicole Cook
cook at maya.com
Thu Feb 22 12:07:21 EST 2001
I'm running python 1.5.2 on windows98 and using mxODBC to talk to an Access
database. I'm having no trouble reading information from the database, but
now I want to write something to a column.
So I do :
db = ODBC.Windoes.connect("accessdb")
cs = db.cursor()
cs.execute("UPDATE Project SET Item='"+item+"' WHERE Name='"+name+"'")
When I do this from the interpreter it returns 1, when I use it as a line
in a function Access freezes until I quit python. Either way, nothing
happens to the column in the db that I'm trying to write. Is there
something else I have to do to get mxODBC to execute an update?
Nicole
More information about the Python-list
mailing list