Not sure why it says my previous reply has been deleted but here it is again:
Hi Massimo I am not familiar with the method you suggested but when I tried it, I got the following error: print db(Expression(db,"business_view.loc && ST_MakeEnvelope(42.179139323652443, 141.20906066894531, 42.307520083522473, 143.34776306152344)")).select().as_list() NameError: global name 'Expression' is not defined In any case, in the non-working example that I tried, I was trying to use the bounding box operator in postgis, which is not currently available in the DAL... With the approach I suggested, I managed to get it to work without issues. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.