<div class="gmail_quote">On Thu, Nov 26, 2009 at 10:03 AM, Carsten Haese <span dir="ltr"><<a href="mailto:carsten.haese@gmail.com">carsten.haese@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
cursor.execute('update products set pic1=%s where ID=1',<br>
(MySQLdb.Binary(pic1),))<br>
<br>
[That comma between the two closing parentheses is not a typo. Do not<br>
leave it out!]<br></blockquote><div><br>A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.<br> /var/www/html/<a href="http://angrynates.com/cart/addEdit.py">angrynates.com/cart/addEdit.py</a><br>
85 print '<body>\n</html>'<br> 86 db.commit()<br> 87 cursor.close()<br> 88 <br> 89 addEdit()<br>addEdit = <function addEdit><br> /var/www/html/<a href="http://angrynates.com/cart/addEdit.py">angrynates.com/cart/addEdit.py</a> in addEdit()<br>
66 id = 0<br> 67 cursor.execute(sql)<br> 68 cursor.execute('update products set pic1=%s where ID=1' (MySQLdb.Binary(pics[0]),))<br> 69 for col in colNamesPics:<br>cursor = <MySQLdb.cursors.Cursor object>, cursor.execute = <bound method Cursor.execute of <MySQLdb.cursors.Cursor object>>, 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\x02\x01\x00H\x00H\x00\x00\xff\xe1\x13\xd5Exif\x00\x00MM\x00*\x00\x00\x00\x08\x00\x07\x01\x12\x00\x03\x00\x00\x00\x01...\xdb\x9f\x94\xa9\xfds\xc9y\xb1W\xda\xd66\x9azS\x84\xd1\x1f\x93\xa9\xfdG\x0fm\xe3\x84\x01\xc5\x94\xfc\x88\xcf\x06f\xc5_\x7fPS6x\x076*\xff\x00\xff\xd9', '', '']<br>
<br>TypeError: 'str' object is not callable<br> args = ("'str' object is not callable",) <br><br>Please advise.<br>TIA,<br>V<br></div></div>