last version is working ok (1.99.7), what web2py version are you using ? if db.contadores is a table, then it definitely has a "_count" method...
Il giorno venerdì 9 marzo 2012 15:55:42 UTC+1, Fabiano Faver ha scritto: > > Niphlod, this is what i got, using distinct argument or not: > > Traceback (most recent call last): > File "C:\web2py\gluon\restricted.py", line 204, in restricted > exec ccode in environment > File "C:/web2py/applications/OPM/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, line > 613, in <module> > File "C:\web2py\gluon\globals.py", line 172, in <lambda> > self._caller = lambda f: f() > File "C:\web2py\gluon\tools.py", line 2533, in f > return action(*a, **b) > File "C:\web2py\gluon\tools.py", line 2533, in f > return action(*a, **b) > File "C:/web2py/applications/OPM/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, line > 528, in timeline_opm > print db.contadores._count(distinct=db.contadores.id_impressora) > File "C:\web2py\gluon\dal.py", line 5542, in __getattr__ > return self[key] > File "C:\web2py\gluon\dal.py", line 5482, in __getitem__ > return dict.__getitem__(self, str(key)) > KeyError: '_count' > > > > @Bruno > While I can`t get all grouped records at once I am query them individually > one by one using argument distinct > > for dias in range(loop_back): > d = timedelta(days=dias) > dias_passado = dia_hoje - d > header.append(TH(dias_passado.strftime("%d/%m"),_width='60px')) > contador_no_dia = db((db.contadores.id > >0)&(db.contadores.data==dias_passado)).count(distinct=db.contadores.id_impressora) > > Em sexta-feira, 9 de março de 2012 10h54min59s UTC-3, Niphlod escreveu: >> >> ooops, sorry, the _count method is on the table, not the field >> try with >> >> db.contadores._count(distinct=db.contadores.id_impressora) >> >> >> >> Il giorno venerdì 9 marzo 2012 13:37:16 UTC+1, Fabiano Faver ha scritto: >>> >>> I have phpmyadmin to test it but I didn`t manage to get the generated >>> sql using underline. >>> >>> with or without distinct argument it gives >>> >>> Traceback (most recent call last): >>> File "C:\web2py\gluon\restricted.py", line 204, in restricted >>> exec ccode in environment >>> File "C:/web2py/applications/OPM/controllers/default.py" >>> <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, line >>> 610, in <module> >>> File "C:\web2py\gluon\globals.py", line 172, in <lambda> >>> self._caller = lambda f: f() >>> File "C:\web2py\gluon\tools.py", line 2533, in f >>> return action(*a, **b) >>> File "C:\web2py\gluon\tools.py", line 2533, in f >>> return action(*a, **b) >>> File "C:/web2py/applications/OPM/controllers/default.py" >>> <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, line >>> 529, in timeline_opm >>> print >>> db.contadores.id_impressora._count(distinct=db.contadores.id_impressora) >>> AttributeError: 'Field' object has no attribute '_count' >>> >>> >>> Em sexta-feira, 9 de março de 2012 09h13min01s UTC-3, Niphlod escreveu: >>>> >>>> ok, can you print here what is the result of : >>>> >>>> db.contadores.id_impressora._count(distinct=db.contadores.id_impressora) >>>> >>>> (mind the _ before count.) >>>> >>>> If you can fire off queries on your db using another tool than web2py >>>> (let's say, phpmyadmin), try to copy the resulting string into that and >>>> watch if the query raises an error. >>>> >>>> Il giorno venerdì 9 marzo 2012 13:02:49 UTC+1, Fabiano Faver ha scritto: >>>>> >>>>> MySQL >>>>> >>>>> Em sexta-feira, 9 de março de 2012 08h59min46s UTC-3, Niphlod escreveu: >>>>>> >>>>>> what db are you using ? >>>>>> >>>>>> >>>>>> Il giorno giovedì 8 marzo 2012 15:20:17 UTC+1, Fabiano Faver ha >>>>>> scritto: >>>>>>> >>>>>>> I`m trying to select distinct printers used in each day but i`m not >>>>>>> managing to use the distinct argument >>>>>>> >>>>>>> count = db.contadores.id_impressora.count() >>>>>>> for row in db((db.contadores.id >>>>>>> >0)&(db.contadores.data<=today)).select(db.contadores.data,count,groupby=db.contadores.data): >>>>>>> print row.contadores.data, row[count] >>>>>>> >>>>>>> if I use something like >>>>>>> >>>>>>> >>>>>>> db.contadores.id_impressora.count(distinct=db.contadores.id_impressora) >>>>>>> >>>>>>> it gives: >>>>>>> >>>>>>> Traceback (most recent call last): >>>>>>> File "C:\web2py\gluon\restricted.py", line 204, in restricted >>>>>>> exec ccode in environment >>>>>>> File "C:/web2py/applications/OPM/controllers/default.py" >>>>>>> <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, >>>>>>> line 581, in <module> >>>>>>> File "C:\web2py\gluon\globals.py", line 172, in <lambda> >>>>>>> self._caller = lambda f: f() >>>>>>> File "C:/web2py/applications/OPM/controllers/default.py" >>>>>>> <http://127.0.0.1:8000/admin/default/edit/OPM/controllers/default.py>, >>>>>>> line 516, in timeline_opm >>>>>>> count = >>>>>>> db.contadores.id_impressora.count(distinct=('id_impressora')) >>>>>>> TypeError: count() got an unexpected keyword argument 'distinct' >>>>>>> >>>>>>> >>>>>>> How can I use distinct count here? >>>>>>> >>>>>>
