that's essentially what I did in code.
On 5/2/2012 2:14 PM, Richard Vézina wrote:
You could try also this :
a = [ row.ipaddress for row in db().select(db.ips.ipaddress) if
row.ipaddress.split('.')[3] == '35' ]
db(db.ips.ipaddress.belongs(tuple(a))).select(db.ips.ipaddress).first().ipaddress
And for the HAVING clause I solve it earlier this week like this :
list_value = []
count = db.table1.field1.count()
for row in db().select(db.table1.field1, count, groupby=db.table1.field1):
if row[count]>1:
#print row.table1.field1, row[count]
list_value.append(row.table1.field1)
So, if you combine both you should have something that do what you want!
Richard
On Wed, May 2, 2012 at 1:49 PM, Richard Vézina
<[email protected] <mailto:[email protected]>> wrote:
Maybe raw SQL??
Richard
On Wed, May 2, 2012 at 10:54 AM, Larry Wapnitsky
<[email protected] <mailto:[email protected]>> wrote:
Here's the actual query:
http://pastie.textmate.org/3848916
SELECT SUBSTRING_INDEX( ipaddress, '.', 3 ) AS first_three_octet,
count( * ) AS ipCount, updated
FROM ips
GROUP BY SUBSTRING_INDEX( ipaddress, '.', 3 )
HAVING ipCount = 254
ORDER BY ipCount DESC
[feedly mini]
On Tuesday, May 1, 2012 3:19:27 PM UTC-4, Larry Wapnitsky wrote:
In a test (non-web2py) program, I'm using a MySQL query
that invokes SELECT SUBSTRING_INDEX. What is the easiest
way to convert this to the proper usage within web2py's
DAL specifications?
Thanks,
Larry
