I'll elaborate with code and URLs if it helps but I'll start just describing the problem and seeing if anyone can help me out with some ideas.
I have a method which returns some objects as json via a time_query method on my model - the time query takes a couple of parameters date_from and date_to. The method should return objects within that range (date attribute I'm querying is updated_at). This is pretty much for background, it works fine in development, it doesn't behave as expected in production. A small test for me is to simply craft a URL which isolates a single record on the basis of it's updated_at time and returns it to me, ie makes a really tiny time frame between the two dates and get the record I'd expect back - works in dev (i can return a single record), does not work in prod (I can't). I'm stuck. What else causes dev and prod to behave differently in such circumstances? Things I've tried / occured to me - still no luck. 1) caching, am using uncached in my method 2) timezones, env.rb is the same UTC in both 3) browser behaviour, maybe? still need to try this, unlikely though? 4) databases, it's mysql on dev and prod, UTF8, I've just tried dumping the production data to dev and it worked in dev with that production data 5) dates on the server and my mac, I did ./script/console then Time.now and both reported the same as expected 6) apache / passenger config on the server - could this be important? -- 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.

