ODBC / DBI help (via Win32 Extensions)

[S. Hoon Yoon]

I think that's because you should use format #date# on update. Unless, I did
not understand your problems.
That's really more of SQL and access convention rather than Python.
Pls look at the docs for Access and SQL.

UPDATE [BT Dates] SET [BT Dates].[date] = #12/12/2000#;

This is what I get if I use Query wizard and you should follow it.
Hope it helps,


"Benjamin Schollnick" <junkster at nospam.rochester.rr.com> wrote in message
news:rNHvjEdhm5Pp-pn2-RytgtQHbLg9d at d185d18f2.rochester.rr.com...
> ====================================================
>           (Remove "NoSpam" to Email me)
> ====================================================
> Hi All,
>
> I'm doing some MS Access/SQL work via the ODBC & DBI
> modules... and it's working great...
>
> 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.
>
> Can someone possibly post a example, or a fragment of a
> working  UPDATE / INSERT INTO command?  Or point me to some
> python resources that might assist?
>
> I've checked the ODBC how-to's on the python web site, and
> they don't even touch on the subject of WRITING a date... The examples
> on reading were very informative, but obviously I'm doing something
> wrong.
>
> - Benjamin
>
> ====================================================
>           (Remove "NoSpam" to Email me)
> ====================================================
> Please feel free to copy any and or all of this sig.
> A little something for spam bots:
>
> root at localhost postmaster at localhost admin at localhost
> abuse at localhost postmaster at 127.0.0.1
>
> Chairman William Kennard: bkennard at fcc.gov
> Commissioner Susan Ness: sness at fcc.gov
> Commissioner Harold Furchtgott-Roth: hfurchtg at fcc.gov
> Commissioner Michael Powell: mpowell at fcc.gov
> Commissioner Gloria Tristani: gtristan at fcc.gov
> consumerline at ftc.gov
> fccinfo at fcc.gov
> ssegal at fcc.gov
>