[Zope] How to pass arguments to ZSQL-Methods?

Jason Wong jwong@digitalview.com.hk
Mon, 3 Apr 2000 18:59:49 +0800


Stephan

after debugging your code <grin>, I've got it all working now.

cheers
- 
Jason Wong

> SQL_Query (ZSQL Method):
> 
> Arguments:
> 
> table:string
> qry_criteria:string
> qry_column:string="specific"
> qry_item:string="general"
> 
> SQL Body:
> 
> <dtml-if "qry_column != 'specific' ">
>       SELECT DISTINCT &dtml-qry_column; FROM &dtml-table; WHERE 
> &dtml-qry_criteria;
> <dtml-else>
>       SELECT * FROM &dtml-table; WHERE Status='Current' AND 
> &dtml-qry_item; 
> LIKE &dtml-criteria;
> </dtml-if>