Some More MySQL

[Victor Subervi]

I still have this code:

      sql = 'select * from options%s where ID=%%s', (opTable[0].upper() +
opTable[1:])
      cursor.execute(sql, (id,))

which throws this error:

 /var/www/html/angrynates.com/cart/enterOptionsPrices2.py
   70     print 'All options prices have been successfully updated.'
   71     print '</body>\n</html>'
   72
   73 enterOptionsPrices2()
   74
enterOptionsPrices2 = <function enterOptionsPrices2>
 /var/www/html/angrynates.com/cart/enterOptionsPrices2.py in
enterOptionsPrices2()
   58       id = form.getfirst('%sID' % option)
   59       sql = 'select * from options%s where ID=%%s',
(opTable[0].upper() + opTable[1:])
   60       cursor.execute(sql, (id,))
   61 #      cursor.execute('select * from options%s where ID=%s' %
(opTable[0].upper() + opTable[1:], id))
   62       if cursor.fetchone() is not None:
cursor = <MySQLdb.cursors.Cursor object>, cursor.execute = <bound method
Cursor.execute of <MySQLdb.cursors.Cursor object>>, sql = ('select * from
options%s where ID=%%s', 'Sizes'), id = '0.00'
 /usr/lib64/python2.4/site-packages/MySQLdb/cursors.py in
execute(self=<MySQLdb.cursors.Cursor object>, query=('select * from
options%s where ID=%%s', 'Sizes'), args=('0.00',))
  144         db = self._get_db()
  145         charset = db.character_set_name()
  146         query = query.encode(charset)
  147         if args is not None:
  148             query = query % db.literal(args)
query = ('select * from options%s where ID=%%s', 'Sizes'), query.encode
undefined, charset = 'latin1'

AttributeError: 'tuple' object has no attribute 'encode'
      args = ("'tuple' object has no attribute 'encode'",)


Please advise.
TIA
beno
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20100528/4c5d49cf/attachment-0001.html>