Maybe raw SQL?? Richard
On Wed, May 2, 2012 at 10:54 AM, Larry Wapnitsky <[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 > > > 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 >> >
