[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