Jan Eden wrote: > Hi, > > in Perl's DBI, I used fetchrow_hashref() to receive a database row as > a dictionary, with the field names being the dictionary keys. > > MySQLdb's fetchone() returns a tuple Unfortunately, I have a > dictionary of SQL queries which return rows of different lengths > (read: with a varying number of fields). > > The documentation for MySQLdb says that fetchoneDict() is deprecated > and the usage of fetchone() is suggested.
You could just use fetchoneDict(); deprecated isn't the same as gone... > > Is there a recommended way to receive the results of an SQL query in > the form I need? Or do I have to create a dictionary of fieldname > tuples which can be zipped with the query result tuple? You can create a list of field names from the cursor.description attribute. But if the number of fields in the result varies how do you know which field goes with which description? Kent _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
