On 28 Jan 2011, at 17:27, bingo bob <[email protected]> wrote:
> OK, tested...
>
> on my server, in production,
>
> ./script/console
>
>>> App.time_query("2011-01-28 13:58:38","2011-01-28 13:58:38")
> => [#<App id: 700, name: "Dream Home HD", description: "LIMITE.... bla
> bla bla]
Why did you format the dates differently in the console versus in the URL?
Depending on who is parsing those strings it could be obscure differences
between versions if mysql, locale or date libraries (eg if different hosts had
different versions of libicu)
Fred
>>>
>
> so it works... returns a single app as I might expect
>
> in the browser I do...
>
> http://server_ip/apps.json?date_from=2011-01-28T13:58:38Z&date_to=2011-01-28T13:58:38Z
>
> I get
>
> [ ]
>
> So nothing, it doesn't find the app.
>
> in dev on my mac
>
> I do a similar thing
>
> script console
>
>>> App.time_query("2011-01-28 07:07:14","2011-01-28 07:07:14")
> => [#<App id: 1167, name: "Ball Dash Pro", bla bla
>
> one app returned as expected...
>
> browser
>
> http://localhost:3000/apps.json?date_from=2011-01-28T07:07:14Z&date_to=2011-01-28T07:07:14Z
>
> Guess what ?
>
> [{"app":{"name":"Ball Dash
> Pro","popularity":2,"created_at":"2011-01-14T10:00:52Z","seller_name":"NextGen
>
> Entertainment.... bla bla...
>
> One app returned as expected !
>
> what else can I look at ?
>
> --
> 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 [email protected].
> 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.
>
--
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 [email protected].
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.
