similar to: linked table confusion

Have 2 tables - clients & case_managers class Client < ActiveRecord::Base has_one :case_manager end app/views/clients/_form.html contains line... <p><% collection_select("client", "case_manager_id", \ case_manager.find_all, "name", "id") %></p> and this line generates error... undefined local variable or method

I have been working on this for 3 days and haven''t been able to solve it. I have 2 tables... clients belongs_to: case_managers case_managers has_many: clients When entering new clients, I need to have some type of select box that allows me to pick the case_manager (by name) so that the ''id'' field from the case_manager table is inserted into clients.case_manager_id

I have a form...2 tables and using auto_complete table clients id case_manager_id foreign key case_manager_id to case_manager(id) table case_manager id name my app/views/clients/_form.rhtml includes which works (finally!) <%= text_area_auto_complete_for :case_manager :name %> and now in clients_controller.rb def create @client = Client.new(params[:client]) I need to add a line to

because I am a grasshopper... Now that I can sort my ''list''...is there a logical way of not repeating myself to having essentially the same list view with multiple sorts? i.e. def list_cl # ordered by clients last name @placement_pages, @placements = paginate( :placements, :include => [:client], :order_by =>

I have reached a development plateau and now want to integrate some of the rails niceties that I passed over to get the system online. I am fooling with migrations. I am using postgresql. I put in my migration script (at the end of the ''up'' method, the following raw sql code... # set up primary key restratints for PostgreSQL execute ''ALTER TABLE ONLY

Agile book lacks some basic information, perhaps I need to learn ruby as I am lacking information - some basic things - especially debugging. The following are stupid newbie questions and any portion of them answered would be great. 1. If I am viewing a page from app/views/clients/ and on this page, I want to put a ''link_to'' directive to say app/views/case_managers... how do I

Hi: I''m looking to get a point clarified which i''m sure is obvious to everyone else but I haven''t been able to find the answer to. i''ve tried searching through the forums and the api pages and haven''t found anything. Is there a way with migrations to set up foregin key relationships? (beyond putting in the relevant foregin_id attributes) Is

I simply can''t figure this out. I have been reading and re-reading Agile book and wiki.rubyonrails.org - all sorts of validation methods and still, it doesn''t work. Controller code def create @client = Client.new(params[:client]) if @client.save! flash[:notice] = ''Client was successfully created.'' redirect_to :action =>

Hi folks, I''m curious how a lookup with a large group of values would be handled in Rails. For example, I have a (contrived) AnimalType filtering a list of many Animals--more than can be presented comfortably in a dropdown box. Therefore I need to either redirect to another screen to select an animal (returning after the selection is made), or show a dialog--modal or otherwise--to

I''ll try again... I am looking at this page...HowToUseFormOptionHelpers http://wiki.rubyonrails.org/rails/pages/HowtoUseFormOptionHelpers perhaps I should be using Ajax for this...I haven''t looked at Ajax yet. Have 2 tables - clients & case_managers I want the data from a column in case_managers to be the select list on a screen for adding/editing clients as I am pretty

I can''t see how to use variables so I am using console to test things out... clients table - a column named first_name My very brief console session... >> clients = Client.find_by_sql("select * from clients where first_name = FN") ActiveRecord::StatementInvalid: RuntimeError: ERROR C42703 Mcolumn "fn" does not exist Fparse_expr.c L1034

I''m lost on regular expressions to begin with... I''m trying to fix a value to one of 4 radio buttons as there will be value of either 1,2,3 or 4 in @roles_users... <TD><input type="radio" id="roles" name="case_managers[case_manager_name]" value="Case Manager Admin" <% if =~ @roles_users /1/ checked =

I''m trying to figure out how to change the order of a list view and it''s obvious to me that I don''t understand what I get from a simple scaffold to know enough to alter it. If someone would be so kind to tell me what this means ... def list @placment_pages, @placements = paginate :placements, :per_page => 10 end @placement_pages, # I am guessing that this

I am trying to use auto_complete_for to reference a different table. in my clients_controller.rb file auto_complete_for :case_manager :case_manager.name ^^^^^^^^^^^^ this is not the clients table my models/clients.rb has: has_one: case_manager The above ''auto_complete_for'' line in clients_controller.rb

I am not sure that this is entirely a rails question as I am trying to run the command in postgres and I am getting the same error... controller code... @client_slot_count = ClientSlotsDaily.find(:all, :conditions => ["created_at > ? AND created_at < ? AND facility_id = ? AND client_id IS NOT NULL", starting_date, ending_date, @facility.id],

I''m new to ruby and rails and as a result am a bit lost on implementing a one to many relationship. In my DB I have 2 tables contents and locations, contents contains the foreign key location_id. I generated a content and a location model using rails scripts and then edited the models as follows class Content < ActiveRecord::Base has_one :location end class Location <

I thought I was on top of them all, but found another one that has me completely stumped. table referral_notes belongs_to: placement table placements has_many: referral_notes def list_rfn @placement = Placement.find(:all) # possibly unnecessary @referral_note = ReferralNote.find(:all, :include => [:placement], :conditions => ["placement_id = ?",

I think I can have finally reduced my problem to something somebody can help me with. I am using auto_complete... specifically the form command is... <%= text_area_auto_complete_for :case_manager :name %> I need to use the value derived here in my controller... If I use... cm = CaseManager.find(:first, :conditions => "name = ''Thomas E Dewey''") it works.

probably something really simple but I don''t understand. Shifting to Apache to w/ fastcgi (definitely feels faster than webrick) Anyway, I set the default route in routes.rb to be map.connect '''', :controller => "placements", :action => ''list'' which worked once I figured out apache... Anyway, now that I have done that, all attempts

have placements, clients and case_managers tables with relationships Trying to create new placement record...case_manager_id field exists in clients table. I need the value from related clients record in placements table in placements_controller.rb def create @placement = Placment.new(params[:placement]) case_manager_id = Client.case_manager_id # this doesn''t work if