Cool
On Dec 29, 8:56 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 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
