search for: intake_date

I abandoned ruby way for find_by_sql and still can''t get this... @myplacement = Placement.find_by_sql( "select * from placement where :intake_date >= beg_intake_date and :intake_date <= end_intake_date") just a simple date range...it''s killing me - If I knew how to load placement controller into irb, I could probably try out finds interactive mode... Thanks Craig

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 params[:beg_referral_date] != "" then @vw_string2 = ["referral_date between ? and ?", params[:be...

I am playing around with this and reference this wiki from RonR site... http://wiki.rubyonrails.org/rails/pages/CalendarHelper The error I am getting is: NameError in Placements#list undefined local variable or method `date_format'' for #<PlacementsController:0xb78f9ef4> RAILS_ROOT: script/../config/.. Application Trace | Framework Trace | Full Trace