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
--
http://mail.python.org/mailman/listinfo/python-list
