similar to: select list generated from table

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

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

placement.rb has_one :client has_one :case_manager client.rb belongs_to :case_manager has_many :placements case_manager.rb has_many :clients has_many :placements I am trying to create a view file for placements. I can pull columns from clients table in this view by using... <%= @placement.client.wholename %> but if I use <% @placement.case_manager.wholename %>

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.

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

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

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

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

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

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 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''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 =

In development and production, I''ve got postgresql constraints that prevent deleting a CaseManager if there is a Client that belongs to that CaseManager. In unit tests...and obviously in my testing db, those restrictions don''t get added. Is it wrong to test for deleting dependent records in unit tests? Craig --~--~---------~--~----~------------~-------~--~----~ You received

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

am in a bit of a quandry... I have asked postgresql-users list and haven''t gotten anything to work with... > > How do I change the owner of a schema? > > > > ALTER SCHEMA "public" OWNER to "some_user"; #? > > http://www.postgresql.org/docs/current/interactive/sql-alterschema.html > > The docs explain this very situation. HTML

I am trying to allow for AND type ''find'' but to allow for simply a single set of find criteria. controller code... @vw_string = @vw_string1 = @vw_string2 = @vw_string3 = [] if params[:beg_intake_date] != "" then @vw_string1 = ["intake_date between ? and ?", params[:beg_intake_date], params[:end_intake_date] ] end if

I''m making a simple questionnaire app using RoR. I''ve got a model for Questions, a model for Answers, and a third model, Qa, for matching each question to five possible answers through foreign keys. So, each qa has a question and five answers , a1-a5, through belongs_to and a :foreign_key, and then a selected_answer field for specifying which answer was selected by the user. The

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