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
This works for me (Zope 2.4 branch, ZMysqlDA). Do you have a traceback ? Andreas ----- Original Message ----- From: "Joseph J Wolff" <joe@silverwolf.com> To: <zope-dev@zope.org>; <zope@zope.org> Cc: <joe@eracks.com> Sent: Friday, September 28, 2001 15:56 Subject: [Zope] Z SQL Methods appear broken in 2.4.x
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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[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)
I seem to remember a recent thread on this, ending with a minor patch to import the string module. Do a search on the archives. This is best done on the Active State archives at http://aspn.activestate.com/ASPN/Mail/ Cheers, Tom P
participants (3)
-
Andreas Jung -
joe＠silverwolf.com -
Thomas B. Passin