On 7 Sep, 12:08, mcl <[EMAIL PROTECTED]> wrote:
> 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
Sort of solved it.
On that particular table it did not like * for all fields.
Any reason why that would be the case ?
Richard
--
http://mail.python.org/mailman/listinfo/python-list
