similar to: Validations continued

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

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

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

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 am sitting with the Agile book on my desk and scratching my head at the discussion on aggregation - perhaps that isn''t what I need. I have a db called clients. fields include - first_name middle_initial last_name I want to combine them all into one name element in a list view. I can add/edit the fields separately but in the list view, I only want the one combo field. Is there a

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

All of the tutorials and the Agile book use MySQL and I''ve got that working. I am now trying to use PostgreSQL and can''t seem to get going. Is my problem the db setup in postgresql? I have installed postgres-pr The error message when I try to access http://localhost:3000/clients when using PostgreSQL (MySQL works fine) ActiveRecord::StatementInvalid (RuntimeError: ERROR

I have the text_field_with_auto_complete woking on my user DB using last_name. so looking for ''ivanoff'' works great, but I can''t find ''john''. Plus I like to have ''last_name, first_name'' show up in the dropdown. what I can''t figure out is how to concat first_name and last_name to make a name and use that to look it. working

In my controller...this code works def list2 first_name = params[:client][:first_name] @myclients = Client.find(:all, :conditions => ["first_name = :first_name", {:first_name => first_name}]) end this code doesn''t... def list2 first_name = params[:client][:first_name] if first_name searchstring = ''["first_name =

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

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

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 struggling to understand the methodology here... I have a find.rhtml <%= start_form_tag :action => ''list2'', :first_name = client %> <%# render :partial => ''form'' %> <p><label for="client_first_name">First name</label><br/> <%= text_field ''client'', ''first_name''

I would swear that I am tracking exactly the method used in Agile book... TypeError in Placements#edit Showing app/views/placements/_form.rhtml where line #33 raised: wrong argument type String (expected Module) Extracted source (around line #33): 30: <tr> 31: <td><label for "type">Type</label></br><%= 32: options = [["Select

Obviously I am missing something and I don''t know what it is... I am following the instructions at http://rubyforge.org/docman/view.php/381/114/activeldap_rb.html and also here... http://wiki.rubyonrails.org/rails/pages/HowtoAuthenticateViaLdap my model looks exactly like this... class LdapUser < ActiveRecord::Base ldap_mapping :dnattr => ''uid'', :prefix

I want to use select form elements to choose between boolean options. How can I have it default to true and still display the persisted value (either true or false) when editing an existing object? I guess booleans default to false by default so its not obvious how to recognize when it''s a real ''false'' that the user set or default false because the value was null.

This seems rather ugly. I am thinking that this needs to be in the model but I am looking to obtain the date for a tb test... >> @tb = Innoculation.find(:all, :conditions => ["personnel_id = 1 AND innoc_type = ''TB''"], :order => ''innoc_date DESC'') => [#<Innoculation:0xb77ed234 @attributes={"id"=>"1",

I think they are called tool tips... I have view code that looks like this... <%= link_to ''I'', :action => ''edit_innoculations'', :id => personnel %> Is there an option (I don''t see it in api) to have tool tips for a link_to ? Craig

I have an OpenLDAP backend, Samba knows how to talk to it, my Samba users are stored in LDAP and file shares work fine authenticating to the LDAP server. I tried executing smbldap-useradd -w server02 on the command-line and got the following error: failed to perform search; Can't contact LDAP server at /usr/lib/perl5/vendor_perl/5.8.7/smbldap_tools.pm line 362, <DATA> line 283. Error