On 13 November 2012 15:15, Colin Law <[email protected]> wrote: > 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)"
Ah, I think I understand. You have a project_id in params[:id] and you want to find the bookings and hence the weeks for that project id? Why don't you just get the project for the id @project = Project.find params[:id] then the bookings, if you actually need the bookings @bookings = @project.bookings and/or the weeks by @weeks = @project.weeks Colin > > 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.
