[Tutor] Update BLOB with odbc

Ron Phillips RPhillips at engineer.co.summit.oh.us
Wed Aug 2 19:33:34 CEST 2006


It must be easier than I am making it. 

--------------------
            sql = "UPDATE sa2.outfalls SET photo_content = %s WHERE
pppoint_id ='"+record[0].strip()+"';"
            newsql = sql%pstuff
            print newsql[:150]
            cursor.execute(newsql)
______________
the print newsql[:150] => "UPDATE sa2.outfalls SET photo_content =
ÿØÿá*EExif . . . "

and I get this error:

TypeError: argument 1 must be string without null bytes, not str

which sounds reasonable, but I don't know how to fix it. Is there some
escape thing that I'm missing?

Ron


 
 


More information about the Tutor mailing list