Rails - Mar 2008 - query realated to date_select tag

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::
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

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
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---