Hi, The format outputted/updated shows that there is a problem with the quotes. Try doing <dtml-sqlvar url type=string> and check if it works. Bye, A.R.Karthick
I have a database which has information about books, and there should be link to the publishers website.
When I use SQL -insert all goes fine, but when I want to update records which have URL inserted I get an error.
It works if I use html-quote, but then (of course) the link is useless. Can anyone help?
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>
Error Type: sql.error Error Value: ('42000', 1064, '[TCX][MyODBC]You have an error in your SQL syntax near'http://www.bookpress.com">BookPress",