Two search fields

P

Pete Fairley

how can I have 2 search fields on one page? I'm using DRW
but this only caters for one search field. I can add
another, but how do I write the code, or criteria, because
a visitor might enter data in both fields or just one?

Thanks in advance

PF
 
R

Ray

Yes, but I need to allow for the fact that one field has data and the other
does not. In the case where both fields are populated the SQL would be as
follows:

SELECT * FROM tblItem WHERE (fkCondition = '::Condition::' AND
FkItemCategory = '::Category::')

but what do I do if Condition is blank?
 
Top