Hello Mate,

I just double check in the book and the documentation resources
because I was wondering how to actually create a DAL query that
include "Case" statement ?
Like let's say I have an SQL like this :

SELECT salary,
 CASE
 WHEN  salary <= 2000 THEN 'PoorOne'
END AS salary_level
FROM employees
ORDER BY salary ASC


How can I write such a query with "CASE" statement in Web2py ?

Thanks,
Yannick P.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.


Reply via email to