(ok, sorry, i´m spanish.. ;-D)
I´m trying to do something like this in a ZSQLMethod:
    select * from table_name where table_field1=<dtml-sqlvar argument1 type=int>;
 
And it works successfully. But if I try with:
    select * from table_name where table_field2=<dtml-sqlvar argument2 type=string>;
 
I get an unexpected error:
   
Error, exceptions.NameError: global name 'string' is not defined
SQL used:
Could not render the query template!
I have tried some another ways to access the query:
    select * from table_name where table_field2='<dtml-sqlvar argument2 type=string>';
    select * from table_name where table_field2=<dtml-sqlvar argument2 type="string">;
    select * from table_name where table_field2='<dtml-sqlvar argument2 type="string">';
    ...
But, nothing. If i try this:
    select * from table_name where table_field2='value';
It works successfully again.
 
Why can´t Zope render the query template?
Why does Zope say "globla name string is not defined"?
 
I´m using...
    Zope 2.4.0
    Python 2.1.1
    Linux
    ZPoPyDa (Last Version? I´m not sure of this)
I need the Help. Every comments can help me. Thanks.
 
Antonio Carrasco