On 13 November 2012 13:56, Werner <[email protected]> wrote: > Hi Colin.
Please remember to reply to the list and please don't top post, it makes it difficult to follow the thread. Insert your reply inline at appropriate points in the previous message. Thanks. > > 1. I ask for entries in booking with a certain project_id > @bookings = Booking.find_all_by_project_id(params[:id]) > => [#<Booking id: 1, week_id: 47, project_id: 2, hour: 4>, #<Booking id: 2, >> week_id: 48, project_id: 2, hour: 7>] So you know how to do that ok? > > 2. Get the values from the table week which have the week_id from the 1 (47, > 48) Sorry, still don't understand what that is supposed to mean. I presume that you mean records rather than values and the table weeks rather than weeks. So you want to get the records from the table weeks. But that table does not have a column week_id, just id and no idea what you mean by "from the 1(47,48)" Colin > > But how to I ask that? > > > Am Dienstag, 13. November 2012 14:44:09 UTC+1 schrieb Colin Law: >> >> On 13 November 2012 13:34, Werner <[email protected]> wrote: >> > Hi all. >> > I have models: >> > >> > has_many :bookings >> > has_many :projects, :through => :bookings >> > >> > has_many :bookings >> > has_many :weeks, :through => :bookings >> > >> > belongs_to :project >> > belongs_to :week >> > >> > Now I want to get all coresponding entries from the bookings and weeks >> > table >> > filtered by a query. >> > >> > @bookings = Booking.find_all_by_project_id(params[:id]) >> > => [#<Booking id: 1, week_id: 47, project_id: 2, hour: 4>, #<Booking id: >> > 2, >> > week_id: 48, project_id: 2, hour: 7>] >> > >> > I have tried soething like that: >> > Week.includes(:bookings).where('bookings.week_id = ?', @bookings).all >> > #mysql >> > error >> >> Can you explain again what you want to achieve, I do not understand. >> >> Colin >> >> > >> > How to get that working? Thanks for help. >> > >> > >> > >> > >> > >> > >> > >> > >> > -- >> > 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]. >> > To view this discussion on the web visit >> > https://groups.google.com/d/msg/rubyonrails-talk/-/eFNgx7qd94AJ. >> > For more options, visit https://groups.google.com/groups/opt_out. >> > >> > -- 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 https://groups.google.com/groups/opt_out.
