[Zope-dev] Z SQL Methods appear broken in 2.4.x

[Joseph J Wolff]

It appears that Z SQL Methods are broken in 2.4.x.

Specifically, the type=string in a <dtml-sqlvar> is broken -

a simple ZSQL query such as:

select id, cost, name
from choices
where name = <dtml-sqlvar nam type=string>

results in the following error:

exceptions.NameError: global name 'string' is not defined

It's broken on 2.4.0 and 2.4.1, and works fine on 2.2.5, 2.3.0, and 2.3.2 -
in fact, it's in production on our 2.2.5.

Integer parameters work fine.

It's hard to believe that no one else has run into this, and that the stable
2.4.x branch has gotten this far without anyone noticing this - I've even
tried it on 2 different servers running Zope 2.4 (2.4.1 on FreeBSD 4.0, our
production web server, and 2.4.0 on FreeBSD 4.3, our dev server)

Any ideas?

Regards,
joe

Joseph J Wolff
eRacks Open Source Rackmount Systems
www.eracks.com
joe@eracks.com