On Wednesday, January 7, 2015 1:02:57 AM UTC-8, Przemysław wrote: > > I've made some experiments with "groupby" but every time it has reduced > the selection to one 'city' and one 'institution'. The other 'institutions' > belonging to the 'city' are omitted. The same situation is when using pure > SQL query via database browser so it is a matter of the functionality of > SQL. Maybe I'm missing something but I not able to get more then one record > using "GROUP BY". > > Perhaps then a try with "orderby" might help. You got me to look up "groupby", which I had mis-remembered.
/dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
