Empty fields are getting pushed to mysql. Any ideas? Thanks, -Christian
I am using the latest pull from the repository, commit 830e447fc5c97647f0e9 I am also using these plugins: http://github.com/activescaffold/active_scaffold_sortable (recent pull) http://github.com/xn/active_scaffold_tools (my fork of) http://github.com/xn/active_scaffold_export (my fork of) error: Processing ApplicantHelmsController#index (for 76.183.250.240 at 2010-05-10 16:09:57) [GET] Parameters: {"search"=>{"status"=>"", "city"=>{"from"=>"", "to"=>"", "opt"=>"%?%"}, "updated_at"=>{"from"=>{"month"=>"", "day"=>"", "year"=>""}, "to"=>{"month"=>"", "day"=>"",\ "year"=>""}}, "zip"=>{"from"=>"", "to"=>"", "opt"=>"%?%"}, "case_worker"=>"", "lastname"=>{"from"=>"", "to"=>"", "opt"=>"%?%"}, "firstname"=>{"from"=>"john", "to"=>"", "opt"=>"\ %?%"}, "current_revision_number"=>{"from"=>"", "to"=>"", "opt"=>"="}, "phone"=>{"from"=>"", "to"=>"", "opt"=>"%?%"}, "address"=>{"from"=>"", "to"=>"", "opt"=>"%?%"}, "created_at\ "=>{"from"=>{"month"=>"", "day"=>"", "year"=>""}, "to"=>{"month"=>"", "day"=>"", "year"=>""}}, "state"=>{"from"=>"", "to"=>"", "opt"=>"%? %"}, "email"=>{"from"=>"", "to"=>"", "op\ t"=>"%?%"}}, "commit"=>"Search"} Questionaire Load (0.3ms) SELECT id, name FROM `questionaires` User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.`id` = '63') LIMIT 1 SQL (0.4ms) BEGIN User Update (0.4ms) UPDATE `users` SET `perishable_token` = 'jadQ_RzLYCOEk0AsjZxA', `updated_at` = '2010-05-10 16:09:57', `last_request_at` = '2010-05-10 16:09:57' WHERE `id` =\ 63 SQL (13.0ms) COMMIT SQL (0.0ms) Mysql::Error: Operand should contain 1 column(s): SELECT count(DISTINCT `applicants`.id) AS count_all FROM `applicants` LEFT OUTER JOIN `users` ON `users`.id = `app\ licants`.case_worker_id LEFT OUTER JOIN `statuses` ON `statuses`.id = `applicants`.status_id LEFT OUTER JOIN `disbursements` ON disbursements.applicant_id = applicants.id LEFT O\ UTER JOIN `contact_logs` ON contact_logs.applicant_id = applicants.id WHERE ((((`applicants`.`updated_at` = '--- \n- from\n- ! map:HashWithIndifferentAccess \n month: \"\"\n day:\ \"\"\n year: \"\"\n','--- \n- to\n- !map:HashWithIndifferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n') AND (`applicants`.`firstname` LIKE '%john%') AND (`applicants`.`c\ urrent_revision_number` = 1) AND (`applicants`.`created_at` = '--- \n- from\n- !map:HashWithIndifferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n','--- \n- to\n- !map:Hash\ WithIndifferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n')) AND (`applicants`.`updated_at` = '--- \n- from\n- ! map:HashWithIndifferentAccess \n month: \"\"\n day: \"\"\n \ year: \"\"\n','--- \n- to\n- !map:HashWithIndifferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n') AND (`applicants`.`firstname` LIKE '%john%') AND (`applicants`.`current_r\ evision_number` = 1) AND (`applicants`.`created_at` = '--- \n- from \n- !map:HashWithIndifferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n','--- \n- to\n- !map:HashWithIndi\ fferentAccess \n month: \"\"\n day: \"\"\n year: \"\"\n'))) My AS config in my controller: active_scaffold :applicant do |config| config.actions.add :revision config.revision.columns = [:firstname, :lastname, :email, :case_worker, :status, :disbursements, :applicant_answers, :updated_by] config.actions.add :export config.export.columns = [:id, :firstname, :lastname, :email, :phone, :address, :city, :state, :zip, :lat, :lng, :created_by, :updated_by, :created_at, :updated_at, :current_revision_number, :status, :applicant_answers, :applicant_memberships, :contact_logs, :disbursements] config.export.default_deselected_columns = [:status, :applicant_answers, :applicant_memberships, :contact_logs, :disbursements, :filed_questionaires] config.export.default_delimiter = ';' config.export.force_quotes = true config.actions.add :print_list config.print_list.columns = [:id, :firstname, :lastname, :email, :phone, :address, :city, :state, :zip, :lat, :lng, :created_by, :updated_by, :created_at, :updated_at, :current_revision_number, :status, :applicant_answers, :applicant_memberships, :contact_logs, :disbursements, :filed_questionaires] config.print_list.default_deselected_columns = [:status, :applicant_answers, :applicant_memberships, :contact_logs, :disbursements, :filed_questionaires] config.print_list.font_size = 8 config.print_list.default_full_download = true config.print_list.maximum_rows = 10000 config.print_list.empty_field_text = '-' config.print_list.header_text = 'Applicants' config.actions.add :field_search config.columns = [:id, :firstname, :lastname, :email, :phone, :address, :city, :state, :zip, :lat, :lng, :created_by, :updated_by, :created_at, :updated_at, :current_revision_number, :status, :applicant_answers, :applicant_memberships, :contact_logs, :disbursements, :filed_questionaires, :case_worker] config.list.columns = [:firstname, :lastname, :case_worker, :status, :disbursements, :contact_logs, :intake] config.show.columns = [:firstname, :lastname, :case_worker, :status, :disbursements, :total_disbursements_requested, :total_disbursements_paid, :phone, :email, :address, :city, :state, :zip] config.update.columns = [:firstname, :lastname, :phone,:email, :address, :city, :state, :zip, :case_worker, :status, :organizations ] config.create.columns = [:firstname, :lastname, :phone,:email, :address, :city, :state, :zip, :case_worker, :status, :organizations ] config.list.empty_field_text = "----" config.list.per_page = 15 config.list.label = "Applicants" config.field_search.columns = [:firstname, :lastname, :email, :phone, :address, :city, :state, :zip, :created_at, :updated_at, :case_worker, :status, :current_revision_number] config.columns[:filed_questionaires].label = "Edit Intake" config.columns[:contact_logs].label = "Referral Logs" config.columns[:status].search_sql = 'status_id' config.columns[:status].search_ui = :record_select config.columns[:status].options = {:multple => true} config.columns[:status].form_ui = :record_select config.columns[:applicant_answers].search_sql = 'applicant_answers.id' config.columns[:applicant_answers].search_ui = :select config.columns[:applicant_answers].options = {:multple => true} config.columns[:applicant_answers].form_ui = :record_select config.columns[:applicant_memberships].search_sql = 'applicant_memberships.id' config.columns[:applicant_memberships].search_ui = :select config.columns[:applicant_memberships].options = {:multple => true} config.columns[:applicant_memberships].form_ui = :record_select config.columns[:contact_logs].search_sql = 'contact_logs.id' config.columns[:contact_logs].search_ui = :select config.columns[:contact_logs].options = {:multple => true} config.columns[:contact_logs].form_ui = :record_select config.columns[:disbursements].search_sql = 'disbursements.id' config.columns[:disbursements].search_ui = :select config.columns[:disbursements].options = {:multple => true} config.columns[:disbursements].form_ui = :record_select config.columns[:filed_questionaires].search_sql = 'filed_questionaires.id' config.columns[:filed_questionaires].search_ui = :select config.columns[:filed_questionaires].options = {:multple => true} config.columns[:filed_questionaires].form_ui = :record_select config.columns[:lat].search_ui = :numeric config.columns[:lng].search_ui = :numeric config.columns[:created_at].form_ui = :calendar config.columns[:created_at].search_ui = :calendar config.columns[:updated_at].form_ui = :calendar config.columns[:updated_at].search_ui = :calendar config.columns[:case_worker].search_sql = 'case_worker_id' config.columns[:case_worker].search_ui = :record_select config.columns[:case_worker].options = {:multple => true} config.columns[:case_worker].form_ui = :record_select config.columns[:current_revision_number].search_ui = :numeric end -- You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en.
