[web2py] Re: Query results from 2 children tables from same parent ordered by date

[Mamisoa Andriantafika]

ok find it too using this code in view:

{{for e in exams_mutex:}}
<div><h1>Examen du {{=e['COALESCE(dataset1.date,dataset2.date)']}}</h1></div
>
{{pass}}


Le samedi 22 décembre 2012 08:27:03 UTC+1, Mamisoa Andriantafika a écrit :
>
> I actually need to display those coalesce dates out of SQLTABLE that I use 
> in view.
> To be precise, I need to show in LI(date, LI(all parameters)).

--