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

Anthony Baxter Anthony Baxter <anthony@interlink.com.au>
Mon, 10 Jan 2000 23:47:21 +1100


>>> 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