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