pysqlite2 fetching from select different than pysqlite?

schwehr at gmail.com schwehr at gmail.com
Thu Jul 27 17:04:28 EDT 2006


Dennis Lee Bieber wrote:

> 	cursor.description -- after an .execute() has selected data.

Thanks Dennis,  The desciription works, but gives some funky results,
but with python it is not a big deal.

cu.description

(('activity_id', None, None, None, None, None, None),
 ('case_id', None, None, None, None, None, None),
 ('incident_dt', None, None, None, None, None, None),
 ('activity_type', None, None, None, None, None, None),
 ('vessel_id', None, None, None, None, None, None),
 ('waterway_name', None, None, None, None, None, None),
 ('event_type', None, None, None, None, None, None),
 ('event_class', None, None, None, None, None, None),
 ('event_subclass', None, None, None, None, None, None),
 ('activity_role', None, None, None, None, None, None),
 ('damage_status', None, None, None, None, None, None),
 ('latitude', None, None, None, None, None, None),
 ('longitude', None, None, None, None, None, None))




More information about the Python-list mailing list