search for: gov_id

I have a model where initially, they we don''t insert an gov_id value because it isn''t known. The field is given a value of "" because it is on the form. I then added code to the ''create'' method to set that value to nil if it is blank which seems to be fine but then it fails this validation (if NULL) validates_length_of...

...39; *** there''s more but I didn''t think I needed to *** Postgres setup... CREATE TABLE clients ( id serial primary key NOT NULL, first_name character varying(25) NOT NULL, middle_initial character varying(1) NOT NULL, last_name character varying(25) NOT NULL, gov_id character varying(18) NOT NULL, dob date ); MySQL setup CREATE TABLE `clients` ( `id` int(8) NOT NULL auto_increment, `first_name` varchar(25) NOT NULL default '''', `middle_initial` char(1) NOT NULL default '''', `last_name` varchar(25) NOT NULL default...

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

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