[web2py] Re: Adding custom operators to DAL

2013-06-27 Thread Calvin
Thanks for the clarification but in any case, I thought it was Google acting up! -- --- 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...@googl

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Massimo Di Pierro
I do not know either why it was deleted. Google did it not, us. Sorry. On Wednesday, 26 June 2013 10:53:34 UTC-5, 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

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Calvin
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 >>

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Anthony
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 followi

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Calvin
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.30

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Calvin
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 '

[web2py] Re: Adding custom operators to DAL

2013-06-26 Thread Massimo Di Pierro
Can you show an example of how you plan to use something like this. I believe there is already a method db(Expression(db," ... raw query ...")).select() perhaps I do not understand. On Tuesday, 25 June 2013 22:36:45 UTC-5, Calvin wrote: > > I think it would be nice to specify custom operators