[Zope-DB] How to send comparison operations (such as > = ) to Z SQL?

Qingliang Li qlli at ctb.pku.edu.cn
Fri Jul 16 09:15:04 EDT 2004


Thanks for your relply. Maybe I can't state my question clearly.
I mean it raise error when i try the following example:

    select * from BAMD
       <dtml-sqlgroup where>
            .....
       <dtml-sqltest ID op=<dtml-var myOperation> type=nb optional>
            .....

where the myOperation is a variable (it could be "eq", "gt", etc.).
Is there a method that can handle such a problem?

Thanks.





Dieter Maurer wrote:

>Qingliang Li wrote at 2004-7-15 22:46 +0800:
>  
>
>>...
>>I want to send operations of "eq"/"gt"/"ne" ...(=, >, ....)  to  the 
>>"op"  according to user in the web interface.
>>    
>>
>
>Look at "comparison_operators" at the end of ".../Shared/DC/ZRDB/sqltest.py"
>(the "dtml-sqltest" source).
>
>Alternatively: it supports the operators you expect -- in the usual
>spelling (e.g. "le" for "<=").
>
>  
>


-- 
Qingliang Li
Center for Theoretical Biology,
Peking University, Beijing,
P.R.China, 100871

Email: qlli at ctb.pku.edu.cn
Tel: +86-010-6275-9669



More information about the Zope-DB mailing list