Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?

Quote Reply
Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW? In reply to
   
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

Smile
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
Subject Author Views Date
Thread PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW? kevinws 4204 Feb 19, 2004, 1:15 PM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
ltillner 4079 Feb 19, 2004, 3:42 PM
Thread Re: [ltillner] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 4064 Feb 20, 2004, 6:56 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
604 4047 Feb 20, 2004, 9:52 AM
Thread Re: [TheStone] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 4039 Feb 20, 2004, 10:24 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 4062 Feb 20, 2004, 10:57 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 4057 Feb 20, 2004, 11:03 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
604 4079 Feb 20, 2004, 4:26 PM
Post Re: [TheStone] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
qango 4009 Feb 26, 2004, 7:06 AM