[Zope] Update URL in SQL

[Dieter Maurer]

helmjan@hotmail.com writes:
 > I have a database which has information about books, and there should
 > be link to the publishers website.
 > ....
 > SQL code:
 > UPDATE info SET name="<dtml-var name>",
 > description="<dtml-var description>",
 > url="<dtml-var url>",
 > publisher="<dtml-var publisher>",
 > update="<dtml-var update>"
 > WHERE id = <dtml-var id>
 > 
 > input url:
 > <a href="http://www.bookpress.com">Book Press</a>
Try:

   UPDATE ....
   url='<dtml-var url sql_quote>'
   ....


Note the change in string delimiters
and the addition of "sql_quote".


Dieter