On Sat, 2012-02-11 at 09:40 -0800, Kevin Murphy wrote: > Hi All, > I'm using Python 2.7 and having a problem creating the cursor below. > Any suggestions would be appreciated! > > import sys > import _mysql > > print "cursor test" > > db = > _mysql.connect(host="localhost",user="root",passwd="mypw",db="python- > test") > > cursor = db.cursor() > > >>> > cursor test > > Traceback (most recent call last): > File "C:\Python27\dbconnect.py", line 8, in <module> > cursor = db.cursor() > AttributeError: cursor
You are using the low-level C API wrapper (not sure why). Most people, I believe, would use the pythonic API: >>> import MySQLdb >>> db = MySQLdb.connect(host='localhost', user='root', passwd='mypw', db='python-test') >>> cursor = db.cursor() The low-level API is... well.. for when you want to do low-level stuff. You probably want the pythonic API. -a -- http://mail.python.org/mailman/listinfo/python-list
