Yes you are right... I just puch as far as I can for this one to touch the limit... Though the reason was to make use of Row and dot notation to access data because I manipulate them a lot and using slicing would make my code much less redable.
I think there is a way to initialise Row on db.executesql, I will have read about that. Thanks Richard On Fri, May 16, 2014 at 9:42 PM, Joe Barnhart <[email protected]>wrote: > Hi Richard -- > > When using special DB features, sometimes it's best just to fall back to > the old "executesql" function. It works really well for those complex > joins and special functions that are just too seldom-used to be > special-cased in the DAL. > > In fact, when I was forced to use it not long ago, I was amazed at how > simple and direct it was. It really made a messy query into a clean one. > > -- Joe > > > On Wednesday, May 14, 2014 7:46:20 AM UTC-7, Richard wrote: >> >> Hello, >> >> Is there a way to do string_agg() with in web2py for a query that have >> groupby clause? >> >> Richard >> > -- > 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. > -- 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.
