[Zope-DB] how to get all values if input is not defined?

Jaroslav Lukesh lukesh at seznam.cz
Wed Apr 7 15:30:10 EDT 2004

Dear sirs,

I have table X

aa	bb
ab	bc
aa	bd
aa	be

and have ZSQL method:

WHERE   (X.A = <dtml-sqlvar A type="string">)

How to display all table if A is not selected by user?

Yes, it is possible to make "select * from X" and filter-out unwanted 
results in DTML method. But it is not what I want because table is 
really big and I need to make dtml-in batch query limit.

Many thanks for your help,


Jaroslav Lukeš

Tento e-mail nemůže obsahovat VIRY
jelikož nepocházi z virózního systému M$ Windows!

More information about the Zope-DB mailing list