Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Dynamically generate a drop-down field for a field... (Andy)

Just thought I would post this... as it seems to work a treat for me =)

Code:
sub { 

   my $field = $_[0]; 

   my $table = $DB->table('Links'); 
   my $sth = $table->select( ["DISTINCT($field)"] ); 

   my $back = qq|<select name="$field">|; 

   while (my ($name) = $sth->fetchrow_array) { 
     $back .= qq|<option>$name</option>|; 
   } 

   $back .= '</select>'; 
   return $back; 
}

Code:
<%global_name('FieldName')%>

For example,

Code:
<%select_GEN('Country')%>

.. which would then generate a select box called "Country".

Enjoy Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

Subject	Author	Views	Date
Dynamically generate a drop-down field for a field...	Andy	17111	Aug 28, 2004, 12:49 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	sangiro	16613	Aug 28, 2004, 1:49 AM

Re: [sangiro] Dynamically generate a drop-down field for a field...	Andy	16607	Aug 28, 2004, 1:55 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	ajiimd	16412	Sep 4, 2004, 4:30 PM

Re: [Andy] Dynamically generate a drop-down field for a field...	ajiimd	16492	Sep 5, 2004, 5:29 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	mick31	16354	Apr 22, 2005, 1:08 PM

Re: [mick31] Dynamically generate a drop-down field for a field...	Andy	16319	Apr 23, 2005, 2:16 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	Clint	16312	Apr 24, 2005, 2:20 AM

Re: [Clint] Dynamically generate a drop-down field for a field...	Andy	16446	Apr 24, 2005, 11:49 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	Clint	16552	Apr 24, 2005, 5:19 PM

Re: [Clint] Dynamically generate a drop-down field for a field...	kailew	16276	Dec 17, 2005, 2:16 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Clint	16216	Dec 17, 2005, 2:29 AM

Re: [Clint] Dynamically generate a drop-down field for a field...	kailew	16131	Dec 17, 2005, 2:45 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Clint	16168	Dec 17, 2005, 4:46 PM

Re: [Clint] Dynamically generate a drop-down field for a field...	kailew	16148	Dec 17, 2005, 4:53 PM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	16192	Dec 18, 2005, 11:44 PM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	16185	Dec 19, 2005, 12:41 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	16205	Dec 19, 2005, 2:28 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	16232	Dec 19, 2005, 3:00 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	16167	Dec 19, 2005, 3:08 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	16207	Dec 19, 2005, 3:13 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	16197	Dec 19, 2005, 3:16 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	16160	Dec 19, 2005, 3:22 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	16144	Dec 19, 2005, 3:28 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	16067	Dec 19, 2005, 4:02 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	7706	Dec 19, 2005, 4:03 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	7655	Dec 22, 2005, 12:22 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	7723	Dec 22, 2005, 1:18 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	kailew	7619	Dec 22, 2005, 2:05 AM

Post deleted by kailew	kailew	7710	Dec 22, 2005, 2:42 AM

Re: [kailew] Dynamically generate a drop-down field for a field...	Andy	7654	Dec 22, 2005, 2:56 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	Mark2	7546	Apr 19, 2007, 3:32 PM

Re: [Mark2] Dynamically generate a drop-down field for a field...	Andy	7568	Apr 20, 2007, 12:59 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	Mark2	7568	Apr 20, 2007, 7:00 AM

Re: [Mark2] Dynamically generate a drop-down field for a field...	Andy	7571	Apr 20, 2007, 7:07 AM

Re: [Andy] Dynamically generate a drop-down field for a field...	MJ_	7375	Jul 25, 2009, 6:34 AM

Re: [MJ_] Dynamically generate a drop-down field for a field...	Andy	7425	Jul 26, 2009, 12:34 PM

Re: [Andy] Dynamically generate a drop-down field for a field...	MJ_	7364	Jul 27, 2009, 4:50 AM

Subject

Author

Views

Date

Dynamically generate a drop-down field for a field...

Andy

17111

Aug 28, 2004, 12:49 AM

Re: [Andy] Dynamically generate a drop-down field for a field...

sangiro

16613

Aug 28, 2004, 1:49 AM