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