Victor,
Please give us an example with the python removed and include the
actual syntax error.
-Eric
On Fri, Apr 18, 2008 at 8:41 AM, Victor Subervi <[EMAIL PROTECTED]> wrote:
> Hi;
> The python code works properly, so I assume this is a strictly MySQL
> question now :)
> If I grab an image in the database thus:
>
> sql = "select pic1 from products where id='" + str(id) + "';"
> cursor.execute(sql)
> pic1 = cursor.fetchall()[0][0].tostring()
> # pic1 = cursor.fetchall()[0][0] // either this or the above line
>
> and try and re-insert it thus:
>
> cursor.execute('update products set pic1="%s" where id="%s", ;',
> (pic1, id))
>
> it tells me I have an error in my MySQL syntax. What is the error?
> TIA,
> Victor
>
--
high performance mysql consulting.
http://provenscaling.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
