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