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

At 10:59 PM +1100 1/10/00, Anthony Baxter wrote:

...

...

...

Itamar Shtull-Trauring wrote 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?

Aaron Watters posted a patch for gadfly to fix this

Alternatively, if you don't really want newlines, tabs, etc. in the string, you can do what I do: _.string.join(_.string.split(text)) Or, if you want the newlines and your text is going to be displayed as HTML, you can encode the newlines as break tags. I would avoid creating dependencies on a particular SQL database--you never know when your circumstances will change. joe