List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:April 18 2008 3:41pm
Subject:Working with Images
View as plain text  
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

Thread
Working with ImagesVictor Subervi18 Apr
  • Re: Working with ImagesEric Bergen21 Apr
  • Re: Working with ImagesSebastian Mendel22 Apr