Robert Walker wrote in post #973147:
> Rails 2:
> @flights = Flight.find(:conditions => { :arrival_airport_id =>
> departure_airport_id, :departure_datetime => @date...(@date + 1.day) })
>
> Rails 3:
> @flights = Flight.where(:arrival_airport_id => departure_airport_id,
> :departure_datetime => @date...(@date + 1.day))
>
> SELECT "flights".* FROM "flights" WHERE ("flights"."arrival_airport_id"
> = 1) AND ("flights"."departure_datetime" >= '2011-01-07 17:21:56.932566'
> AND "flights"."departure_datetime" < '2011-01-08 17:21:56.932568')

Oops, The above statements are actually correct but the resulting SQL 
show here was incorrect. Should have been:

SELECT "flights".* FROM "flights" WHERE ("flights"."arrival_airport_id" 
= 1) AND ("flights"."departure_datetime" >= '2011-01-07' AND 
"flights"."departure_datetime" < '2011-01-08')

-- 
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-t...@googlegroups.com.
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to