[Zope] Update URL in SQL

karthick ramanarayanan karthick@pepco.no
Fri, 9 Mar 2001 08:21:32 +0100 (CET)


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",