Thanks for the suggestion Massimo! I haven't been able to get it to work though. That syntax returns an error "TypeError: __init__() takes at least 3 arguments (2 given)" Tried looking at the Expression class defined in DAL.py for what arguments it needs but haven't been able to figure this out. Any more suggestions?
If this does not work we will most likely have to shift to SQL Alchemy and I do like working with the DAL so I am keeping my fingers crossed and hoping there is work around for this. Harkirat On Dec 29, 11:56 am, mdipierro <[email protected]> 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 <[email protected]> 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
