[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