Select_tag

Rails
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

Hope this helps,
Christophe
Le 15 avr. 2010 à 05:56, Kris Mojica a écrit :

3

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

Christophe D. wrote:

You should investigate collection_select
ActionView::Helpers::FormOptionsHelper

Hope this helps,
Christophe
Le 15 avr. 2010 � 05:56, Kris Mojica a �crit :

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