[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

A	B
aa	bb
ab	bc
aa	bd
aa	be

and have ZSQL method:

<params>
A:string=""
</params>
SELECT  *
FROM    X
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