I want to let the default user to view what he search for only and cannot have the View All ability.

What should I edit?

Thanks for ur help! I've use it on some other fields and it works..thanks alot!

In html.pl, sub html_footer, take out the line

print qq!| <A HREF="$db_script_link_url&view_records=1&$db_key=*">List All</A> ! if ($per_view);

If you would like a registered user to be able to "List All," edit the above line to read

print qq!| <A HREF="$db_script_link_url&view_records=1&$db_key=*">List All</A> ! unless ($db_userid eq "default");

To prevent anyone from being able to do a "List All" by entering an * in a field on the search form, in db.cgi sub query, take out the line

($in{$db_cols[$field]} eq "*") and ($tmpreg = ".*"); # A "*" matches anything.



------------------
JPD