Hi :) I need to insert a python string into Postgresql's text field. I'm using a ZSQLMethod with ZPsycopgDA and the template looks like this:
'INSERT INTO records (zope_id, title, long_description) VALUES (<dtml-sqlvar zope_id type="string">, <dtml-sqlvar title type="string">, <dtml-sqlvar long_description type="string">)' long_description is the text field. With most of my data it works fine, but there are some "long descriptions" that are really complicated with lots of quotes (both singular ', as well as double ") and what's worse - they have SQL syntax inside! For those descriptions my ZSQLMethod fails with "Programming Error" :( I really don't know what to do... I've read about dollar-quoting: http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-CONSTANTS but simply adding '$$' at the beginning and at the end of the description does nothing. How can I insert such strings into the database? I really need help. Any suggestions are really appreciated. Best regards, Maciej _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
