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

2000-05-24 Thread Tony Mann
duce 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 statemen

[Zope] Passing multi-line field into SQL

2000-05-23 Thread Tony Mann
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