[Zope] Textareas and SQL (Gadfly)

[Itamar Shtull-Trauring]

Jim Sanford wrote:

> is that gadfly can't handle carriage
> returns and line feeds in the string input. (Which is why I
> was trying things like "virtual" to perhaps get rid of them.)

This is a bug in Gadfly.  If DC ever had time to read the Collector it
might've been in by now.  I'm eagerly awaiting the day when they start
handing out parts of Zope to the public.  Or at the very least make a list
of people who's patches are always read.

You can fix it by replacing
charstre = "'[^\n']*'"
with
charstre = "'[^']*'"

in lib/python/Products/ZGadflyDA/gadfly/sqlgen.py

-- 
Itamar S.T.  itamars@ibm.net