That perfect. I'll get it going next week. Thanks for the help with this. Jim On Apr 12, 2013 8:57 PM, "Anthony" <abasta...@gmail.com> wrote:
> No, you can't do the ._select(). However, IS_IN_DB takes orderby, groupby, > and distinct arguments (though not "left", which presumably could be added) > and uses them in the .select() that it does. You don't expect all this > stuff to be documented, do you? We have to have something to talk about on > Google Groups. ;-) > > Anthony > > On Friday, April 12, 2013 9:41:58 PM UTC-4, Jim S wrote: >> >> In the _select() ? >> On Apr 12, 2013 8:41 PM, "Anthony" <abas...@gmail.com> wrote: >> >>> You can specify an orderby for the query. >>> >>> Anthony >>> >>> On Friday, April 12, 2013 8:20:38 PM UTC-4, Jim S wrote: >>>> >>>> So, that should allow me to sort though shouldn't it? >>>> On Apr 12, 2013 4:38 PM, "Anthony" <abas...@gmail.com> wrote: >>>> >>>>> Well, a change was just made in trunk to allow >>>>> '%(tablename.fieldname)s' notation, but it looks like the query retains >>>>> only the fields in the main table (db.productSite in this case) anyway, so >>>>> I guess that won't help. So instead, maybe: >>>>> >>>>> lambda r: db(db.product.productId == r.productId).select().first().*** >>>>> *productName >>>>> >>>>> Anthony >>>>> >>>>> On Friday, April 12, 2013 1:56:34 PM UTC-4, Jim S wrote: >>>>>> >>>>>> requires = IS_IN_DB(db((~db.productSite.**p**** >>>>>> roductSiteId.belongs(**currentIt****ems)) & >>>>>> (db.productSite.**availableAddo****n==True) >>>>>> & >>>>>> >>>>>> (db.productSite.siteId==**worko****rder.siteId) >>>>>> & >>>>>> (db.product.productId==db.**pro**** >>>>>> ductSite.productId)), >>>>>> db.productSite.productSiteId, >>>>>> lambda r: r.product.productName, zero='..') >>>>>> >>>>>> ...gives me... >>>>>> >>>>>> Traceback (most recent call last): >>>>>> File "C:\dev\web2py\gluon\**restricte****d.py", line 212, in restricted >>>>>> >>>>>> >>>>>> >>>>>> exec ccode in environment >>>>>> File >>>>>> "C:/dev/web2py/applications/**in****focenter/controllers/**applicati****ons.py" >>>>>> >>>>>> <http://10.10.2.34:8000/admin/default/edit/infocenter/controllers/applications.py>, >>>>>> line 4291, in <module> >>>>>> >>>>>> >>>>>> >>>>>> File "C:\dev\web2py\gluon\globals.**p****y", line 194, in <lambda> >>>>>> >>>>>> >>>>>> >>>>>> self._caller = lambda f: f() >>>>>> >>>>>> >>>>>> >>>>>> File "C:\dev\web2py\gluon\tools.py"******, line 2976, in f >>>>>> >>>>>> >>>>>> >>>>>> return action(*a, **b) >>>>>> File >>>>>> "C:/dev/web2py/applications/**in****focenter/controllers/**applicati****ons.py" >>>>>> >>>>>> <http://10.10.2.34:8000/admin/default/edit/infocenter/controllers/applications.py>, >>>>>> line 864, in workorderBom >>>>>> >>>>>> >>>>>> >>>>>> _formname='addonForm') >>>>>> File "C:\dev\web2py\gluon\sqlhtml.**p****y", line 1599, in factory >>>>>> >>>>>> >>>>>> >>>>>> **attributes) >>>>>> File "C:\dev\web2py\gluon\sqlhtml.**p****y", line 1113, in __init__ >>>>>> >>>>>> >>>>>> >>>>>> inp = self.widgets.options.widget(fi******eld, default) >>>>>> >>>>>> >>>>>> >>>>>> File "C:\dev\web2py\gluon\sqlhtml.**p****y", line 252, in widget >>>>>> >>>>>> >>>>>> >>>>>> options = requires[0].options() >>>>>> File "C:\dev\web2py\gluon\**validator****s.py", line 546, in options >>>>>> >>>>>> >>>>>> >>>>>> self.build_set() >>>>>> File "C:\dev\web2py\gluon\**validator****s.py", line 543, in build_set >>>>>> >>>>>> >>>>>> >>>>>> self.labels = [self.label(r) for r in records] >>>>>> >>>>>> >>>>>> >>>>>> File >>>>>> "C:/dev/web2py/applications/**in****focenter/controllers/**applicati****ons.py" >>>>>> >>>>>> <http://10.10.2.34:8000/admin/default/edit/infocenter/controllers/applications.py>, >>>>>> line 853, in <lambda> >>>>>> >>>>>> >>>>>> >>>>>> lambda r: r.product.productName, zero='..') >>>>>> >>>>>> >>>>>> AttributeError: 'Row' object has no attribute 'product' >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Apr 12, 2013 at 12:10 PM, Jim Steil <ato....@gmail.com>wrote: >>>>>> >>>>>>> Shoot, should have thought of that. >>>>>>> >>>>>>> Will try when I get back to the office. >>>>>>> >>>>>>> Jim >>>>>>> On Apr 12, 2013 12:04 PM, "Anthony" <abas...@gmail.com> wrote: >>>>>>> >>>>>>>> It probably should work, but for some reason, the code converts the >>>>>>>> Row to a dict before doing the string formatting, and that breaks for >>>>>>>> Rows >>>>>>>> involving joins. For now, you can use a lambda instead: >>>>>>>> >>>>>>>> lambda r: r.product.productName >>>>>>>> >>>>>>>> Anthony >>>>>>>> >>>>>>>> On Friday, April 12, 2013 12:38:09 PM UTC-4, Jim S wrote: >>>>>>>>> >>>>>>>>> Tried that already but got the same error. >>>>>>>>> >>>>>>>>> Jim >>>>>>>>> On Apr 12, 2013 11:32 AM, "Anthony" <abas...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Since you are joining tables, you might need to use the >>>>>>>>>> "tablename.fieldname" format to refer to the field in question. Does >>>>>>>>>> '%(product.productName)s' work (assuming "productName" is in the >>>>>>>>>> db.product >>>>>>>>>> table)? >>>>>>>>>> >>>>>>>>>> Anthony >>>>>>>>>> >>>>>>>>>> On Friday, April 12, 2013 11:59:59 AM UTC-4, Jim S wrote: >>>>>>>>>>> >>>>>>>>>>> requires = IS_IN_DB(db((~db.productSite.**p******** >>>>>>>>>>> roductSiteId.belongs(**currentIt********ems)) & >>>>>>>>>>> (db.productSite.**availableAddo****** >>>>>>>>>>> **n==True) & >>>>>>>>>>> (db.productSite.siteId==**worko****** >>>>>>>>>>> **rder.siteId) & >>>>>>>>>>> (db.product.productId==db.**pro****** >>>>>>>>>>> **ductSite.productId)), >>>>>>>>>>> db.productSite.productSiteId, >>>>>>>>>>> '%(productName)s', zero='..') >>>>>>>>>>> >>>>>>>>>>> I get a trace back with this. If I pull out the >>>>>>>>>>> '%(productName)s' it works. But, I want to specify the field name >>>>>>>>>>> to >>>>>>>>>>> display being a field in the table linked by the 4 'anded' query. >>>>>>>>>>> >>>>>>>>>>> Help? >>>>>>>>>>> >>>>>>>>>>> -Jim >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> --- >>>>>>>>>> You received this message because you are subscribed to a topic >>>>>>>>>> in the Google Groups "web2py-users" group. >>>>>>>>>> To unsubscribe from this topic, visit >>>>>>>>>> https://groups.google.com/d/**to******pic/web2py/vb0268kC_mc/** >>>>>>>>>> unsubsc******ribe?hl=en<https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en> >>>>>>>>>> . >>>>>>>>>> To unsubscribe from this group and all its topics, send an email >>>>>>>>>> to web2py+un...@**googlegroups.com. >>>>>>>>>> For more options, visit https://groups.google.com/**grou****** >>>>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> -- >>>>>>>> >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to a topic in >>>>>>>> the Google Groups "web2py-users" group. >>>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/* >>>>>>>> *to****pic/web2py/vb0268kC_mc/**unsubsc****ribe?hl=en<https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en> >>>>>>>> . >>>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>>> web2py+un...@**googlegroups.com. >>>>>>>> For more options, visit https://groups.google.com/**grou**** >>>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> -- >>>>> >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/**to >>>>> **pic/web2py/vb0268kC_mc/**unsubsc**ribe?hl=en<https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en> >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> web2py+un...@**googlegroups.com. >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>> topic/web2py/vb0268kC_mc/**unsubscribe?hl=en<https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en> >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+un...@**googlegroups.com. >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/vb0268kC_mc/unsubscribe?hl=en. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.