Re: [Rails] Re: sql help

2017-04-14 Thread Joe Guerra
Thanks. This worked. On Friday, April 14, 2017 at 12:59:08 PM UTC-4, nanaya wrote: > > Hi, > > On Sat, Apr 15, 2017, at 01:50, Joe Guerra wrote: > > ok, I've got it working but... > > > > <%= Product.where( ['id =?', iu.product_id ]).pluck("title") %> > > > > > > *It's got [' '] around

Re: [Rails] Re: sql help

2017-04-14 Thread Colin Law
On 14 Apr 2017 5:50 p.m., "Joe Guerra" wrote: ok, I've got it working but... <%= Product.where( ['id =?', iu.product_id ]).pluck("title") %> Assuming that you have setup your relationships so that iu belongs_to product you can say iu.product.title Colin On Friday,

Re: [Rails] Re: sql help

2017-04-14 Thread nanaya
Hi, On Sat, Apr 15, 2017, at 01:50, Joe Guerra wrote: > ok, I've got it working but... > > <%= Product.where( ['id =?', iu.product_id ]).pluck("title") %> > > > *It's got [' '] around my title.* > Short fix is you probably want `Product.find(iu.product_id).title`. [' '] you're seeing is

[Rails] Re: sql help

2017-04-14 Thread Joe Guerra
ok, I've got it working but... <%= Product.where( ['id =?', iu.product_id ]).pluck("title") %> *It's got [' '] around my title.* On Friday, April 14, 2017 at 12:43:42 PM UTC-4, Joe Guerra wrote: > > I need to return a product title from an id. I've tried the following... > > <%=