On Fri, Mar 26, 2010 at 09:03:11AM +0800, Christopher Chan wrote:
On Friday, March 26, 2010 08:52 AM, Ray Van Dolson wrote:
On Fri, Mar 26, 2010 at 08:23:26AM +0800, Christopher Chan wrote:
On Thursday, March 25, 2010 09:11 PM, JohnS wrote:
On Thu, 2010-03-25 at 14:14 +0800, Christopher Chan wrote:
Is it me or does the MySQLdb module in Centos not support python's DBAPI 2.0
Well you give no clue to the code your using. Post what type your using,
It uses cursors so it it is compliant as far as I see.
I get you installed it and it is dbapi 2.
What does your python code look like?
The same as everything below except for the initialize() call.
db = MySQLdb.connect (dsn='192.168.0.1:your_db', user='root', password='password') ########################## def addEntry(names):
cursor.initialize() cursor = db.cursor ()###########################
I think a good idea would be to drop it and go to postgres, and import pgdb.
I would love to were it not for the fact that one of the target clients runs OpenSolaris and does not package a postgresql module for python. Grr...
Thanks, I will give this another shot before I give up on learning python and go back to perl or php land.
db = MySQLdb.connect(....) cursor = db.cursor()
con=MySQLdb.connection(...) con.ping() curs = con.cursor()
Traceback (most recent call last): File "<stdin>", line 1, in ? AttributeError: cursor
cursor.execute("SELECT....") results = cursor.fetchall()
However:
con.query("SELECT SF.MOBILE FROM SF") res=con.store_result() res.fetch_row()
Will work.
Unless you want to tell me that things are slightly different when running the script and doing things interactively...
Strange. I've always done it exactly the way I shared in my code snippet. Have many scripts coded that way...
Where'd you get your MySQLdb module from?
Ray