You enter a line break by pressing the Enter key!
We are using Gadfly for right now, until our Oracle db server is set up.
We actually found a solution:
<dtml-var "'\''"><dtml-var "_.string.replace(description ,'\n','<br>')"
sql_quote><dtml-var "'\''">,
Kind of ugly, but it works. I imagine there are more elegant solutions.
Note that I used dtml-var to produce a single quote to avoid nasty nested
quote issues.
..tony..
=================================
In article <[EMAIL PROTECTED]>, Tony
Mann <[EMAIL PROTECTED]> writes
>We have a form with a textarea on it, that can contain line breaks. When we
>try to pass it into an SQL statement
How do you enter line breaks into a text area?
What database adapter are you using?
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )