[Zope] How can you insert strings with newlines into SQL database?

[Anthony Baxter]

>>> Itamar Shtull-Trauring wrote
> I have an SQL method:
> 
> 	insert into mytable (col) values (<dtml-sqlvar text type="string">)
> 
> the problem is that if 'text' contains a newline character gadfly won't
> accept this, since this apparently violates SQL syntax.  So I can't insert
> strings that have newlines.  What should I do?

Aaron Watters posted a patch for gadfly to fix this - you might
want to check either the Zope list archives or the gadfly list
archive (at egroups.com). It should probably be applied to the
version that's in the Zope CVS....

Anthony

-- 
Anthony Baxter     <anthony@interlink.com.au>   
It's never too late to have a happy childhood.