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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
