[Zope] Passing multi-line field into SQL

Tony Mann tony@intelligenesis.net
Tue, 23 May 2000 18:01:55 -0400


We have a form with a textarea on it, that can contain line breaks. When we
try to pass it into an SQL statement

  <dtml-sqlvar textarea_value type=string>

we get a parsing error, due to the embedded newlines.

We would like to convert the newlines to "<BR>" strings. Does anyone have an
easy solution for doing this?

We have tried using split/dtml-in and split/join in the SQL, but getting
these statements past the SQL parser, with all the quotes, has proven to be
tricky.

..tony..