Re: [Zope] Passing multi-line field into SQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In article <[EMAIL PROTECTED]>, Tony Mann <[EMAIL PROTECTED]> writes >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: > >')" >sql_quote>

Re: [Zope] Passing multi-line field into SQL

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: ')" sql_quote>, Kind of ugly, but it works. I imagine there are more elegant solutions. Note that I used dtml-var to produce a single qu

Re: [Zope] Passing multi-line field into SQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 ad

[Zope] Passing multi-line field into SQL

We have a form with a textarea on it, that can contain line breaks. When we try to pass it into an SQL statement we get a parsing error, due to the embedded newlines. We would like to convert the newlines to "" strings. Does anyone have an easy solution for doing this? We have tried using s