Thanks Anthony and Massimo. It all works now!

On Thursday, 27 June 2013 00:42:26 UTC+8, Anthony wrote:
>
> from gluon.dal import Expression
>
> Anthony
>
> On Wednesday, June 26, 2013 11:53:34 AM UTC-4, Calvin wrote:
>>
>> 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.


Reply via email to