Hi Folks

Let's say I have search form with fields like these, for
Organizational Entities:
o Name
o Code
o Cost center
o Fund

My customer wants a search option with 2 choices:
o Match all
o Match any

meaning that if the Entity's name and fund are entered, then 'match
all' will operate like AND on those 2 fields and 'match any' will
operate like OR.

Now, has anyone developed logic to handle building the SQL in cases
like this?

I searched CPAN for modules named 'match', and found 27 modules, but
none at first glance seemed to offer a solution.

--
Cheers
Ron Savage, [EMAIL PROTECTED] on 14/06/2003
http://savage.net.au/index.html


Reply via email to