dealing with special characters in Python and MySQL

[fumanchu]

ronrsr wrote:
> code for storing to database:
>
>         querystring = "update zingers set keywords = '%s', citation =
> '%s', quotation = %s'       where zid = %d" %
> (keywords,citation,quotation,zid)

You're missing a single quote in there around the quotation %s.

Are you also replacing "\\" with r"\\" ? You should be.


Robert Brewer
System Architect
Amor Ministries
fumanchu at amor.org