My Darned Image Again

[Victor Subervi]

Hi;
I'm having trouble loading my image again. Here's my code:

      for pic in pics:
        sql = 'update %s set %s=%s where SKU=%s;' % (store, colNamesPics[i],
'%s', sku)
        sql = sql, (MySQLdb.Binary(pics[int(i)]),)
        cursor.execute(sql, (MySQLdb.Binary(pics[int(i)]),))
        print sql
        i += 1

Here's the beginning of what it prints to screen:

('update products set pic1=%s where SKU=prodSKU1;', (array('c',
'\xff\xd8\xff\xe0\x00\x10JFIF\x00\x01\x01\x01\x00`\x00`\x00\x00\xff\xdb\x00C\x00\x08\x06\x06\x07\x06\x05\x08\x07\x07\x07\t\t\x08

It throws this error:

 /var/www/html/angrynates.com/cart/addEdit.py
  102   db.commit()
  103   cursor.close()
  104
  105 addEdit()
  106
addEdit = <function addEdit>
 /var/www/html/angrynates.com/cart/addEdit.py in addEdit()
   88         sql = sql, (MySQLdb.Binary(pics[int(i)]),)
   89         print sql
   90         cursor.execute(sql, (MySQLdb.Binary(pics[int(i)]),))
   91         i += 1
   92   except MySQLdb.IntegrityError:
cursor = <MySQLdb.cursors.Cursor object>, cursor.execute = <bound method
Cursor.execute of <MySQLdb.cursors.Cursor object>>, sql = ('update products
set pic1=%s where SKU=prodSKU1;', (array('c', ['\xff', '\xd8', '\xff',
'\xe0', '\x00', ...]),)), global MySQLdb = <module 'MySQLdb' from
'/usr/lib64/python2.4/site-packages/MySQLdb/__init__.pyc'>, MySQLdb.Binary =
<function Binary>, pics =
['\xff\xd8\xff\xe0\x00\x10JFIF\x00\x01\x01\x01\x00`\x00`\x00\x00\xff\xdb\x00C\x00\x08\x06\x06\x07\x06\x05\x08\x07\x07\x07\t\t\x08\n\x0c\x14\r\x0c\x0b\x0b\x0c\x19\x12...f\x0b\xe5\xf9\x8b\xefR\xe7\xa1\xa2\xa3#"+)f8\x08EjZh\xff\x007\xcd\xde\xb5S\xc8\xdb\xf2&\xd3\xe9V!PO\xa5d\xf5W\xb8\xf9-\xb9\xff\xd9'],
builtin int = <type 'int'>, i = 0
 /usr/lib64/python2.4/site-packages/MySQLdb/cursors.py in
execute(self=<MySQLdb.cursors.Cursor object>, query=('update products set
pic1=%s where SKU=prodSKU1;', (array('c', ['\xff', '\xd8', '\xff', '\xe0',
'\x00', ...]),)), args=(array('c', ['\xff', '\xd8', '\xff', '\xe0', '\x00',
...]),))
  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 = ('update products set pic1=%s where SKU=prodSKU1;', (array('c',
['\xff', '\xd8', '\xff', '\xe0', '\x00', ...]),)), query.encode undefined,
charset = 'latin1'

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

What do?
TIA,
Victor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091208/279a8daa/attachment.html>