Two search fields

[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

 

[Net55]

Just add another criteria on more options in the DRW

 

[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?