Vili,
I don't know any model what can be a Mercedes AND a Audi AND a Fiat AND ....
What about a "or" search ?
select * from vehicles where model = 'MERCEDES'
OR model = 'AUDI'
OR model = 'FIAT'
OR model = 'FORD'
OR model = 'OPEL'
the unchecked Models are not listed in this case...
Or you can use the "IS IN" search argument (if your model name is in a text
field and if you have more as one Modelsname in the fild)
regards
Daniel
----- Original Message -----
From: "Vili Cankar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 16, 2004 1:26 PM
Subject: Witango-Talk: Checkbox for database criteria
Hi,
I just wonder if someone can help me with this problem:
I have following SQL statement:
select * from vehicles where model = 'MERCEDES'
and model = 'AUDI'
and model = 'FIAT'
and model = 'FORD'
and model = 'OPEL'
I know how to display models from database with check box that I want to
include them in the criteria. (There are no fixed models in the sistem, they
are read from table in database.)
Is it better to use DIRECT DBMS or SEARCH ACTION and would someone give me a
hint how to build queryes for users who just check checkboxes next to the
right models ?
Regards, Vili CANKAR
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
