Hi !
Simple, i upgraded my Web2py version.
I use this sentence
count = db.regis.portid.count()
rows = SQLTABLE(db(db.regis.protocol=='udp').select(db.regis.portid, count,
orderby=db.regis.portid, groupby=db.regis.portid),
headers={'regis.portid':'N° Port',str(db.regis.portid.count()):'Times'},
This situation is so rare,
I have the same problem with the current version, but I did not have this
problem with version 2.8.2-stable + timestamp.2013.11.28.13.54.07
why can't i see a simple count like the prior version? .
i use this sentence:
rows = SQLTABLE(db(db.mydata.protocol=='udp').se
info.number',
'COUNT(info.number)']sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD<_sre.SRE_Pattern
object>'.'.joinundefinedsqlrows.db._adaptersqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.matchsqlrowscolumnsNone
El jueves, 13 de marzo de 2014 12:53:48 UTC-3, Massimo Di
lrows.db).groupsundefinedsqlrows.colnames['info.number',
'COUNT(info.number)']sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD<_sre.SRE_Pattern
object>'.'.joinundefinedsqlrows.db._adaptersqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.matchsqlrowscolumnsNone
El jueves, 13 de marzo de 2014 12:4
Hi !
I have 2.9.4-stable version on my Server1 and 2.8.2-stable version on my
Server2.
the same Application and query on Server1 and Server2:
rows = SQLTABLE(db(db.info).select(db.info.name,
db.registros_chile.number.count(), orderby=db.info.number,
groupby=db.info.number))
Server2 : Correc
do a count distinct ?
> That is supported by DAL (check the book)
>
> On Thursday, February 20, 2014 3:31:18 PM UTC+1, Fcosqui wrote:
>>
>> Hi !
>>
>> I want to translate this query to Web2py format, but i have found nothing
>> in Documentation
>>
&
Hi !
i have this simple problem.
Example:
rows = SQLTABLE(db(db.info).select(db.info.port.count(), headers={' *whats
is the name of this Field ?* ':'new_name'} ) )
i tried, but isn't the real field : info._extra['Count(port)']
Thnx.
--
Resources:
- http://web2py.com
- http://web2py.com/b
Hi !
I want to translate this query to Web2py format, but i have found nothing
in Documentation
SELECT COUNT(ip) from (SELECT ip FROM info GROUP BY ip) as b;
i don't want to use "executesql"
someone can help me?
thnx
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation
8 matches
Mail list logo