Hi,
> With so few fields, sticking with one report isn't
> out of the question. Don't know if you're using
> this technique:
>
> my $lname = $q->param('lname') || '%';
>
> So all fields not filled/selected by the user are
> wildcards by default. A completely empty form
> pulls all data in the relevant tables.
Hmm, doing a
... column-name LIKE '%' ...
isn't slower than including nothing?
I mean (warning!, no escaping):
push @where, "lname LIKE '$lname'"
if $lname;
And:
$where = '';
$where = "WHERE ".join(' AND ', @where)
if @where;
Bye,
Andras
