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

[Itamar Shtull-Trauring]

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?

-- 
Itamar S.T.  itamars@ibm.net