select_tag

rubyonrails-talk
1

a stupid question from a newbie..

how can i populate my select_tag with the values from a SELECT DISTINCT statement?

thanks for bearing with my stupidity..

2

You should investigate collection_select http://api.rubyonrails.org/classes/ActionView/Helpers/FormOptionsHelper.html#M001625

Hope this helps, Christophe

3

thanks a lot! so it's collection_select.. i'll try this one out. thanks again. ^^

Christophe Decaux wrote:

4

Hai Kris ,

I am also a newbie in ROR.Hope this will help you.....

case 1:(If your table has only distinct elements, go for collection_select)

eg. Here we hav a "District" table with fields "id" and "name" index.html.erb <%= collection_select(nil, :district_id, @districts, :id, :name,{:include_blank=>'All'},{})

controller def index @districts=District.find(:all) end

case 2:(If your table has duplicate elements and you want only distinct elements to be populated in it)

eg: Here we hav a "Station" table with one field as "district"

index.html.erb <%= select(:post,:district, @districts,{:include_blank=>'All'},{} )%> controller def index @districts = Station.find(:all, :select=>'district', :order =>"district").map{ |t| t.district }.uniq end