On 25/02/2005 Dennis Lee Bieber wrote: > On Thu, 24 Feb 2005 23:10:48 +0100, Jonas Meurer <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > > version used placeholders as well. anyway, i changed my code to resemble > > "resemble" is the key... It is NOT the correct sample. > > > 261 db_connect.cursor.execute("""UPDATE Images SET Image=%s WHERE > > 262 ImgID = %s""" % (image, imgid)) > 262 ImgID = %s""" , (image, imgid)) > > The .execute method ITSELF performs the argument conversion into > the place holders, including applying what ever quoting is required. > YOUR version is using the Python formatting operator, which does NOT > handle database quoting.
oh, your correct. sorry for the noise. now it works quite good. bye jonas -- http://mail.python.org/mailman/listinfo/python-list