[web2py] Displaying count and groupby PROBLEMS with new version

2014-04-09 Thread Fcosqui
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'},

[web2py] Re: displaying count and groupby

2014-04-02 Thread Fcosqui
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

[web2py] Re: Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-14 Thread Fcosqui
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

[web2py] Re: Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-14 Thread Fcosqui
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

[web2py] Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-13 Thread Fcosqui
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

[web2py] Re: SQL Muli Select to Web2py format

2014-02-22 Thread Fcosqui
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 >> &

[web2py] How can i change the Label of_extra['count()'] in SQLTABLE headers ?

2014-02-22 Thread Fcosqui
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

[web2py] SQL Muli Select to Web2py format

2014-02-20 Thread Fcosqui
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