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.. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
You should investigate collection_select http://api.rubyonrails.org/classes/ActionView/Helpers/FormOptionsHelper.html#M001625 Hope this helps, Christophe Le 15 avr. 2010 à 05:56, Kris Mojica a écrit :> 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.. > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
thanks a lot! so it''s collection_select.. i''ll try this one out. thanks again. ^^ Christophe Decaux wrote:> You should investigate collection_select > http://api.rubyonrails.org/classes/ActionView/Helpers/FormOptionsHelper.html#M001625 > > Hope this helps, > Christophe > Le 15 avr. 2010 � 05:56, Kris Mojica a �crit :-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.