similar to: options_from_collection_for_select

Hello all I am wondering how rails handles case sensitivity in databases. If I do a Person.find_all_by_name("tim") in mysql I would expect to get tim, TIm, and Tim. Do I only get tim in postgres? How do other people deal with this? Do you resort to find_by_sql for all your postgres queries to get case insensitive results?

My observe_form is basically totally limp. I think it should update without hitting submit button but even if I hit it , it doesn''t change (doesn''t seem to post the data). Can anyone please take a look and see if I"m doing something wrong. TIA Form: <% start_form_tag({:action => "livesearch"}, :id => "asearch") %>

I''m trying to use options_from_collection_for_select to generate options for a multiple select: <select id="metro_area_states" name="states[]" size="10" multiple="multiple"> <%= options_from_collection_for_select State.find(:all), :id, :name, @metro_area.states %> </select> When selecting values for the first time, it works

Hi Community.... I''m new in this game, so this might be a easy question, but I have done my google, without result, so I will try this.... I''m learning ROR, and I''m using Patrick Lens ''Ruby on Rails'' book. (This is written for ror 1.x - and I''m using NetBeans 6.1 - ror 2.x - this might be the problem...) But... I have made this

I have a table with first_name and last_name, and wan''t to populate a drop-down with the id and the person''s name consisting of the first and last names concatenated together. Can''t figure out how to tell options_from_collection_for_select to do that. Any ideas? I basically need to do something like: <%= options_from_collection_for_select @media_creators,

I''m in Rails 2.1, Ruby 1.8.6 -- http://pastie.org/211063 <%= params[:doctor_id] %> <%= options_from_collection_for_select(Doctor.active, :id, :name, :selected => params[:doctor_id]) %> <%= options_from_collection_for_select(Doctor.active, :id, :name, :selected_value => params[:doctor_id]) %> Returns: 53 <option value="49">Michael

I need to add a blank or dashed field to the options_from_collection_for_select helper but can''t seem to get it to work. Tried this, but with no effect: <%= options_from_collection_for_select @airlines, ''id'', ''name''], {:include_blank=>true} %> Anyone know how to do this? Thanks, -S -- Posted via http://www.ruby-forum.com/.

i am kind of desparated i try with options_from_collection_for_select to get option values, but it says You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.inject but @customers is not empty -> def get_customer @customers=Customer.find_all end i have tested it and also the attributes "id"

I ran into a problem using options_from_collection_for_select : ActiveRecord::AssociationTypeMismatch (Topic expected, got String): /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/ active_record/associations/association_collection.rb:128:in `raise_on_type_mismatch'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/

Hi everyone, I''m stuck on something that seems to be super easy, but maybe I''m just too tired to see the obvious answer. I''m trying to make a drop down with select_tag and options_from_collection_for_select. I''m trying to fill this drop down list with different human races (white, black, hispanic, etc. in the database under the name field, with a unique id

Anyone know how I could trunicate the names of a passed in array in options_from_collection_for_select? I tried a few things but nothing worked. Any ideas would be appreciated! <%= options_from_collection_for_select available_projects, :id, :name, @selected_project_id %> -- Posted via http://www.ruby-forum.com/.

hey, i need a select list with a id property and not name, cuz i just ajax with this list and it checks on id not name if @request.post? #called by ajax if @request.xml_http_request? #called by ajax @geotag_id=params[:geotag_id].nil? ? -2 : params[:geotag_id] else @geotag_id=params[:geotag][:id].blank? ? -1:params[:geotag][:id] end else @geotag_id = -1 end i use this @geotags =

I have a drop down of country''s and I would like the USA to be the first displayed. I have tried: <select id = "user_w_country" name ="user[w_country]" onchange = "<%=func%>"> <%= options_from_collection_for_select @country, ''id'', ''country'', :selected =>

Hi everyone, I am a newbee in RoR and i could use some help. I have a select box populated by: <select name = "test_company" id = "test_company"> <option selected value=test.company.to_s>Create New </option> <%= options_for_select Company.find(:all, :conditions => ["name =?", test.company], :order => "id asc").collect{|c|

The following code shows a list of the users, with username being each person''s initials (mine would be DM). &lt;%= options_from_collection_for_select @users,"id","username" %&gt; However, I''d like to have the display of the SELECT box be "DM - Dylan Markow" instead of "DM." Is this possible using

I have just started using RoR and am creating some select boxes on my form with the following code: <%= select_tag(options_from_collection_for_select(Owner.all, :id, :fname)) %> My problem is that it does NOT return the first record from the table, but just the second and succeeding records. Does anyone have any ideas on how I can get the first record included in the select box? Thanks.

I''m having problems to make the selected works, i''ve been trying with select and options_from_collection_for_select. I''ve tried, :selected, :selected_key, :selected_value, and all i can got from the doc page ( http://rubyonrails.org/api/classes/ActionView/Helpers/FormOptionsHelper.html#M000399 ) and from wiki. Code: select(''informacao'',

I am doing the recipe/category example, but with a has_many_and_belongs_to relationship. To select categories for a recipe, I have a select control. When editing, I want the proper categories selected. In order to get it to work, I put this in my _form.rhtml: <select id="recipe_categories" name="recipe[category_ids][]" size="4" multiple> <%=

Is there a way to sort the sql result set that populates the options_from_collection_for_select?? Thanks -- 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

Hey, I am trying to get a select list with a selected value in it. Even if I put in an integer, like this, <%= select_tag(fruit.id, "<option>No Contract</option>" + options_from_collection_for_select(@fruit_types, "id", "kind", 3)) %> the list still displays the first option (No Contract) in the list. What am I doing wrong? I''ve looked