ODBC / DBI help (via Win32 Extensions)

Brian Fritz brianfr at grace.speakeasy.org
Tue May 2 16:35:00 CEST 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.

Brian




More information about the Python-list mailing list