Greetings Everyone..
In the conditions of your query you should pass the parameters as simple
strings.
User strftime to get the desired string representation while passing it to
the query
I'd try this:
@orders=Order.find(:all,:conditions => ['created_at BETWEEN "?" AND "?"',
start_date.strftime('%Y-%m-%d %H:%M:%S'), end_date.strftime('%Y-%m-%d
%H:%M:%S')])
the format above is the one u mentioned as the default of your database
engine "Format in db is 2003-10-14 12:37:51"
On Mon, Oct 6, 2008 at 1:16 PM, Katsuo Isono <
[EMAIL PROTECTED]> wrote:
>
> I am having difficulty passing datetime values to a method in the
> controller. I get sql syntax error from the following. Can someone
> advise me what I am doing wrong?
>
> my view:
>
> <table>
> <tr>
> <%= start_form_tag :action => 'time_range' %>
> <td ><%= datetime_select("sd", "time_range") %></td>
> <td ><%= datetime_select("ed", "time_range") %></td>
> <td><%= submit_tag 'go'%></td>
> </tr>
> </table>
>
> my method:
>
> def time_range
> start_date=params[:sd]
> end_date=params[:ed]
> @orders=Order.find(:all,:conditions => ['created_at BETWEEN ? AND ?',
> start_date, end_date])
>
> end
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
--
Mahmoud Said
Software Developer
blog.modsaid.com
www.eSpace.com.eg
+20-16-1223857
--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
