You should be able to doL
from gluon.dal import Expression
db(query).select(Expression("CASE WHEN 1=1 THEN 0 ELSE 1 END"));
Nut I never tried.
On Dec 29, 8:37 am, Harkirat <harkira...@gmail.com> wrote:
> Hi All !
> I am new to web2py and my company is building an enterprise
> level web application that will run on the desktop and also mobile
> apps using web2py! So far it has been a gr8 experience working with
> web2py and kudos to all the developers that made such an awesome
> framework !
>
> I am trying to write some queries in the DAL that require a CASE
> statement e.g.
> SELECT CASE WHEN 1=1 THEN 0 ELSE 1 END
>
> Is there a way to write this in the DAL?
>
> Thanks in advance for your help!
>
> Harkirat
