i have two date select tag like:in view
<%= date_select:date1,:order=>[:year,:month,:date] %>
<%= date_select:date2,:order=>[:year,:month,:date] %>
and in controller i write
@infos = Info.find(:all, :conditions => [“dt between ? and ?”,
params[:date1], params[:date2]])
but the query can;t execute.the error is
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ‘’— \n-
orderyearmonthdate(2i)\n- “3”\n’,’— \n- orderyearmonthdate(3i)\n- ’
at line 1: SELECT * FROM infos WHERE (dt between ‘— \n-
orderyearmonthdate(1i)\n- “2008”\n’,’— \n- orderyearmonthdate(2i)\n-
“3”\n’,’— \n- orderyearmonthdate(3i)\n- “16”\n’ and ‘— \n-
orderyearmonthdate(1i)\n- “2008”\n’,’— \n- orderyearmonthdate(2i)\n-
“3”\n’,’— \n- orderyearmonthdate(3i)\n- “16”\n’)
what should i do?
please help…very urgent…
please provide :simple code::
On Mar 16, 7:42 am, Subhadip Chakraborty <rails-mailing-l…@andreas-
s.net> wrote:
i have two date select tag like:in view
<%= date_select:date1,:order=>[:year,:month,:date] %>
<%= date_select:date2,:order=>[:year,:month,:date] %>
and in controller i write
@infos = Info.find(:all, :conditions => [“dt between ? and ?”,
params[:date1], params[:date2]])
but the query can;t execute.the error is
[snip]
what should i do?
You need to use select_date instead of date_select (date_select is
like text_field and so on: it expects to be used to update or create
an instance of an ActiveRecord object. select_date is more like
text_field_tag). Then you need to realise (look at your logs) that the
date is submitted as its indidual components (ie year, month, day) and
you need to turn that back into an actual date or time (eg via
Date::civil or Time.now).
Fred