[web2py] Re: SQL Muli Select to Web2py format

2014-02-22 Thread Fcosqui
're right ! i didn't know this sentence count distinct ( im not a professional dba :P) thnx! El jueves, 20 de febrero de 2014 17:57:27 UTC-3, Niphlod escribió: web2py's DAL has no support for subselects, so unfortunately there's no current DAL-way to translate that query. BTW: your

[web2py] Re: SQL Muli Select to Web2py format

2014-02-20 Thread Niphlod
web2py's DAL has no support for subselects, so unfortunately there's no current DAL-way to translate that query. BTW: your query doesn't make sense to me (I'm a professional dba in real life). You're just counting how many distinct values of ip are in the table why bother with a subselect