I just modified like this and now works emilinatin duplicates and also searching by options!
thanx Stone for your help!!!


this is what i use in the html

<%status_distinct('t_phonec')%>
<select name="phonec_status">
<option value=''>--</option>
<%loop loop_select%>
<option value="<%phonec_status%>"><%phonec_status%></option>
<%endloop%>
</select>

and the global changed like:

sub {
my $results = $DB->table('t_phonec')->select(['DISTINCT phonec_status'])->fetchall_hashref;
return { loop_select => $results };
}

i took off the column1


i hope this help for others that want to use distinct to eliminate scalar values in a select field that take data from a table. and want this select be used for searching.!
KevinW ANDRE
webmaster@cyberbrickell.com