You don't need the all because the joins call, along with where and group, is returning an array of objects for you that meet your criteria. Remove your . All and call page on the instance variable (which you might want to rename to pages or something else plural).
You don't need the . All because the joins call, along with where and group, is returning an array of objects for you that meet your criteria. Remove your .
All and call page on the instance variable (which you might want to rename to @pages or something else plural).
Thanks for your reply, I changed the code to @prices = Price. Select("prices. *").
Joins(:retailer, :retailer => :profile). Where('product_id=? AND size_id=?', params:prod_id, params:si_id).
Group(:retailer_id). Order("SUM((prices. Price * #{params:amount.
To_i}) + profiles. ShippingCost)"). Page(params:page) But now I receive this error – Philip Mar 31 at 15:53 Column 'retailer_id' in field list is ambiguous: SELECT COUNT(*) AS count_all, retailer_id AS retailer_id FROM prices INNER JOIN retailers ON retailers.
Id = prices. Retailer_id INNER JOIN profiles ON profiles. Retailer_id = retailers.
Id WHERE (product_id='1' AND size_id='3') GROUP BY retailer_id,retailer_id ORDER BY SUM((prices. Price * 1) + profiles. ShippingCost) – Philip Mar 31 at 15:54 When using the in the view – Philip Mar 31 at 15:55 I guess you need to change your .
Joins statement to . Joins(:retailer => :profile) I mean, :retailer is duplicated. – Akira Matsuda Mar 310 at 1:55.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.