select_tag

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..

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

Hope this helps,
Christophe

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

Christophe Decaux wrote:

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