Can you please check again. I have added the suggested fix you suggested. On Wednesday, 23 January 2013 09:05:40 UTC-6, Jim S wrote: > > 2.4.1-alpha.2+timestamp.2013.01.23.08:17:15 > > Just updated this morning. > > -Jim > > On Wed, Jan 23, 2013 at 8:55 AM, Massimo Di Pierro > <[email protected]<javascript:> > > wrote: > >> Which version? I thought we fixed this in trunk. >> >> >> On Wednesday, 23 January 2013 08:54:38 UTC-6, Jim S wrote: >>> >>> Oh, and the problem is that the grid only displays the data from the >>> primary table. The join 'works', but there is no data for the joined >>> tables in the grid. >>> >>> -Jim >>> >>> On Wednesday, January 23, 2013 8:53:55 AM UTC-6, Jim S wrote: >>>> >>>> Just updated to the latest version and am still having this problem. >>>> To be specific, I can do this: >>>> >>>> query = (db.feedLoad.deliverOn==datetime.datetime.today())&(db.feedLoad >>>> .siteId==1) >>>> >>>> left = [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId >>>> ), >>>> db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine. >>>> feedOrderId)] >>>> >>>> rows = db(query).select(db.feedLoad.ALL, db.feedOrder.ALL, db. >>>> feedOrderLine.ALL,left=left) >>>> for row in rows: >>>> print row >>>> >>>> >>>> >>>> >>>> But I can't do this: >>>> >>>> query = (db.feedLoad.deliverOn==datetime.datetime.today())&(db.feedLoad >>>> .siteId==1) >>>> >>>> fields = [db.feedLoad.siteId, db.feedOrderLine.productSiteId, db. >>>> feedLoad.deliverOn, db.feedLoad.loadNumber, >>>> db.feedOrder.customerName, db.feedOrder.customerCityState, >>>> db.feedOrder.dropShipName, db.feedOrder.dropShipCityState, >>>> db.feedLoad.driverId, db.feedOrder.orderNumber, >>>> db.feedOrderLine.productNumber, db.feedOrderLine.productName] >>>> >>>> left = [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId >>>> ),db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine. >>>> feedOrderId)] >>>> >>>> grid = SQLFORM.grid(query, fields=fields, left=left, >>>> create=False, deletable=False, >>>> details=False, csv=False, >>>> editable=False, searchable=False, >>>> paginate=200) >>>> >>>> >>>> >>>> >>>> >>>> It would be great to get this working or let me know what I'm doing >>>> wrong with my grid. >>>> >>>> Thanks - Jim >>>> >>>> On Friday, January 18, 2013 8:25:01 AM UTC-6, Jim S wrote: >>>>> >>>>> I just saw this post as well: >>>>> https://groups.google.com/forum/#!topic/web2py/T1TkWEu2cX4 >>>>> >>>>> Can we get his fix implemented? >>>>> >>>>> -Jim >>>>> >>>>> On Friday, January 18, 2013 8:21:35 AM UTC-6, Jim S wrote: >>>>>> >>>>>> I tried that, but then I don't get any of my joined fields in the >>>>>> result. Here is what I used for the join. >>>>>> >>>>>> left = >>>>>> [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId), >>>>>> >>>>>> db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine.feedOrderId)] >>>>>> >>>>>> I get no fields from either feedOrder or the feedOrderLine tables, >>>>>> only fields from feedLoad. >>>>>> >>>>>> -Jim >>>>>> >>>>>> On Friday, January 18, 2013 5:39:03 AM UTC-6, DenesL wrote: >>>>>>> >>>>>>> Hi Jim, >>>>>>> >>>>>>> from the book: >>>>>>> "Multiple left joins can be combined by passing a list or tuple of >>>>>>> db.mytable.on(...) to the left attribute." >>>>>>> >>>>>>> Denes >>>>>>> >>>>>> -- >> >> >> >> > >
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
