Kind of makes sense that it failed based on the SQL sentence it produces.
What about something like this:
Event.find_by_sql("select events.* FROM events INNER JOIN venues ON
venues.id = events.venue_id WHERE venue.locality = 'London'")
Let me know,
C
On Wed, May 25, 2011 at 5:49 AM, Michael Baldock <[email protected]>wrote:
> Ah ok,
>
> I had read this document, the reason I didn't find what I was looking
> for was that the associations in here were all opposite to my needs, eg
> - one of the examples is
>
> time_range = (Time.now.midnight - 1.day)..Time.now.midnight
> Client.joins(:orders).where(:orders => {:created_at => time_range})
>
> where a Client presumably has_many orders, and an Order belongs_to a
> client.
>
> I was looking for something like as you say:
>
> Event.join(:venue).where(:venue => { :locality => "London" })
>
> where an Event belongs_to a Venue, and a venue has many events. looking
> that way round
>
> Unfortunately, the exact line you give returns
>
> undefined method `join' for #<Class:0x104b2fd68>
>
> trying 'joins' instead returns:
>
> SQLite3::SQLException: no such column: venue.locality: SELECT "events".*
> FROM "events" INNER JOIN "venues" ON "venues"."id" = "events"."venue_id"
> WHERE ("venue"."locality" = 'London')
>
> there definitely is a column in venue called locality!
>
> I think I tried this as part of my searching, but kept getting errors
> along these lines.
>
> Is there an easy way to make the query, when an Event belongs_to a
> Venue, and I'm searching using an attribute in the Venue model.
>
> Thanks for your help
>
> Mike
>
> --
> 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.
