M
mcl
I have just started with python and MySQL.
I have a simple test for each of my tables.
The first two work as expected, but the third 'qlooks', gives a
ValueError.
If I copy and paste the SQL in the traceback to phpMyAdmin, it works
as expected.
Can anyone give a clue as to what I am doing wrong
Python 2.4
MySQL 4.1.22-standard
The tablename qlooks is LOWERCASE
Code =======================================================
cursor = gv.conn.cursor()
queries = ["%septi%"]
fields = ("qlTitle", "qlSubTitle", "qlPostCode", "qlMap",
"qlDetails")
tblFields = "select * from qlooks "
whereTests = 'Where qlTitle like "%septi%"'
sql = tblFields + whereTests
#cursor.execute(sql)
cursor.execute('select * from PERMS')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.execute('select * from LISTS')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.execute('select * from qlooks')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.close()
ERROR TRACEBACK ++++++++++++++++++++++++++++++++++++++++
79 print "Row=", row, gv.nl
80 cursor.execute('select * from qlooks')
81 row = cursor.fetchone()
82 print "Row=", row, gv.nl
cursor = <MySQLdb.cursors.Cursor instance>, cursor.execute = <bound
method Cursor.execute of <MySQLdb.cursors.Cursor instance>>
/usr/lib/python2.4/site-packages/MySQLdb/cursors.py in
execute(self=<MySQLdb.cursors.Cursor instance>, query='select * from
qlooks', args=None)
93 """
94 del self.messages[:]
95 return self._execute(query, args)
96
97 def _execute(self, query, args):
self = <MySQLdb.cursors.Cursor instance>, self._execute = <bound
method Cursor._execute of <MySQLdb.cursors.Cursor instance>>, query =
'select * from qlooks', args = None
/usr/lib/python2.4/site-packages/MySQLdb/cursors.py in
_execute(self=<MySQLdb.cursors.Cursor instance>, query='select * from
qlooks', args=None)
112 exc, value, tb = exc_info()
113 del tb
114 self.errorhandler(self, exc, value)
115 self._executed = query
116 return r
self = <MySQLdb.cursors.Cursor instance>, self.errorhandler = <bound
method Connection.defaulterrorhandler of ...l.connection open to
'db.sabren.com' at 936cac4>>, exc = <class exceptions.ValueError>,
value = <exceptions.ValueError instance>
/usr/lib/python2.4/site-packages/MySQLdb/connections.py in
defaulterrorhandler(connection=<_mysql.connection open to
'db.sabren.com' at 936cac4>, cursor=<MySQLdb.cursors.Cursor instance>,
errorclass=<class exceptions.ValueError>,
errorvalue=<exceptions.ValueError instance>)
31 else:
32 connection.messages.append(error)
33 raise errorclass, errorvalue
34
35
errorclass = <class exceptions.ValueError>, errorvalue =
<exceptions.ValueError instance>
ValueError: invalid literal for int(): 0-
args = ('invalid literal for int(): 0-',)
=========================================
Thanks Richard
I have a simple test for each of my tables.
The first two work as expected, but the third 'qlooks', gives a
ValueError.
If I copy and paste the SQL in the traceback to phpMyAdmin, it works
as expected.
Can anyone give a clue as to what I am doing wrong
Python 2.4
MySQL 4.1.22-standard
The tablename qlooks is LOWERCASE
Code =======================================================
cursor = gv.conn.cursor()
queries = ["%septi%"]
fields = ("qlTitle", "qlSubTitle", "qlPostCode", "qlMap",
"qlDetails")
tblFields = "select * from qlooks "
whereTests = 'Where qlTitle like "%septi%"'
sql = tblFields + whereTests
#cursor.execute(sql)
cursor.execute('select * from PERMS')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.execute('select * from LISTS')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.execute('select * from qlooks')
row = cursor.fetchone()
print "Row=", row, gv.nl
cursor.close()
ERROR TRACEBACK ++++++++++++++++++++++++++++++++++++++++
79 print "Row=", row, gv.nl
80 cursor.execute('select * from qlooks')
81 row = cursor.fetchone()
82 print "Row=", row, gv.nl
cursor = <MySQLdb.cursors.Cursor instance>, cursor.execute = <bound
method Cursor.execute of <MySQLdb.cursors.Cursor instance>>
/usr/lib/python2.4/site-packages/MySQLdb/cursors.py in
execute(self=<MySQLdb.cursors.Cursor instance>, query='select * from
qlooks', args=None)
93 """
94 del self.messages[:]
95 return self._execute(query, args)
96
97 def _execute(self, query, args):
self = <MySQLdb.cursors.Cursor instance>, self._execute = <bound
method Cursor._execute of <MySQLdb.cursors.Cursor instance>>, query =
'select * from qlooks', args = None
/usr/lib/python2.4/site-packages/MySQLdb/cursors.py in
_execute(self=<MySQLdb.cursors.Cursor instance>, query='select * from
qlooks', args=None)
112 exc, value, tb = exc_info()
113 del tb
114 self.errorhandler(self, exc, value)
115 self._executed = query
116 return r
self = <MySQLdb.cursors.Cursor instance>, self.errorhandler = <bound
method Connection.defaulterrorhandler of ...l.connection open to
'db.sabren.com' at 936cac4>>, exc = <class exceptions.ValueError>,
value = <exceptions.ValueError instance>
/usr/lib/python2.4/site-packages/MySQLdb/connections.py in
defaulterrorhandler(connection=<_mysql.connection open to
'db.sabren.com' at 936cac4>, cursor=<MySQLdb.cursors.Cursor instance>,
errorclass=<class exceptions.ValueError>,
errorvalue=<exceptions.ValueError instance>)
31 else:
32 connection.messages.append(error)
33 raise errorclass, errorvalue
34
35
errorclass = <class exceptions.ValueError>, errorvalue =
<exceptions.ValueError instance>
ValueError: invalid literal for int(): 0-
args = ('invalid literal for int(): 0-',)
=========================================
Thanks Richard