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

[Jens Vagelpohl]

joe,

please do not cross-post your messages to several zope lists. (see the 
zope list footer...)

i cannot reproduce the error on a 2.4.1-based site...

jens


On Friday, September 28, 2001, at 03:56 , Joseph J Wolff wrote:

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