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	16955	Aug 28, 2004, 12:49 AM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Subject

Author

Views

Date

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

Andy

16955

Aug 28, 2004, 12:49 AM

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

sangiro

16459

Aug 28, 2004, 1:49 AM