ODBC / DBI help (via Win32 Extensions)
brianfr at grace.speakeasy.org
Tue May 2 10:35:00 EDT 2000
Benjamin Schollnick <junkster at nospam.rochester.rr.com> wrote:
> I've got the read, and most of the "write" functions working
> fine, except when it comes to utilizing the date values...
> I can read and convert the date information into a python readable
> value.... But I can't seem to do an UPDATE or INSERT INTO command
> with a date value inside it.
The following line works great for me with SQL Server 7.0:
mycursor.execute( "update database set date_changed = '19990429 11:20' \
where some_column = 'some_value' " )
Haven't messed with Access, but it should work the same.
More information about the Python-list