how to mysqldb dict cursors

[Paul McNett]

Vaibhav.bhawsar wrote:
> I have been trying to get the DictCursor working with mysqldb module but 
> can't seem to. I have pasted the basic connection code and the traceback 
> from pydev. The connection does open with the default cursor class. 
> can't figure this one out. many thanks.

Try one of:

"""
import MySQLdb, MySQLdb.cursors
conn = MySQLdb.connect(..., cursorclass=MySQLdb.cursors.DictCursor)
"""

-or-

"""
import MySQLdb, MySQLdb.cursors
conn = MySQLdb.connect(...)
cur = MySQLdb.cursors.DictCursor(conn)
"""

I'm going off of memory here, though, but I'm at least close.

Paul