My Darned Image Again
MRAB
python at mrabarnett.plus.com
Tue Dec 8 14:28:40 EST 2009
Victor Subervi wrote:
> 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)
After this, 'sql' will be a string.
> sql = sql, (MySQLdb.Binary(pics[int(i)]),)
After this, 'sql' will be a tuple.
> cursor.execute(sql, (MySQLdb.Binary(pics[int(i)]),))
[snip]
You're passing 'sql', which is a tuple, as the query. What was the
purpose of the previous line?
More information about the Python-list
mailing list