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

...

...

Anthony Baxter wrote Aaron Watters posted a patch for gadfly to fix this - you might want to check either the Zope list archives or the gadfly list archive (at egroups.com). It should probably be applied to the version that's in the Zope CVS....

Ok, I found it:

Anthony Baxter has mentioned a number of times that gadfly barfs on strings with embedded newlines. There is a one line patch to this. In sqlgen.py replace

charstre = "'[^\n']*'"

with

charstre = "'[^']*'"

Sorry! -- Aaron Watters

(this would be a nice patch to apply to the CVS tree :) Anthony