In the namedtuple documentation there's an example:- EmployeeRecord = namedtuple('EmployeeRecord', 'name, age, title, department, paygrade')
import sqlite3 conn = sqlite3.connect('/companydata') cursor = conn.cursor() cursor.execute('SELECT name, age, title, department, paygrade FROM employees') for emp in map(EmployeeRecord._make, cursor.fetchall()): print emp.name, emp.title (I've deleted the csv bit) Surely having to match up the "name, age, title, department, paygrade" between the tuple and the database can be automated, the example is rather pointless otherwise. At the very least one should use the same variable instance for both, but it should be possible to get the tuple names from the database. -- Chris Green ยท -- https://mail.python.org/mailman/listinfo/python-list