Office's Access XP ODBC DBI from PythonWin

Dirk Leas dirkLeas at mac.com
Wed Jun 13 17:43:14 EDT 2001


Anybody luck working w/ DbiDate from query result? Check out the
following:

>>> import dbi, odbc
>>> db = odbc.odbc('testAccess')
>>> cursor = db.cursor()
>>> cursor.execute('select * from person')
0
>>> rows = cursor.fetchall()
>>> rows
[(1, 'Joe Smith', <DbiDate object at 010ED560>), (2, 'Mary Smith',
<DbiDate object at 010CEBC0>)]
>>> str(rows[0][2])
'__builtins__\x00])\n\n\x00\x00\x00\xd0\xb2\x12\x1e'

I'm running the latest of AS's Python with the Win32 extensions against
Office XP Access.

TIA,
D





More information about the Python-list mailing list