Nice!
Thanks Joe
:)
Richard
On Fri, May 23, 2014 at 3:28 AM, Joe Barnhart <joe.barnh...@gmail.com>wrote:
> It's super-easy Richard. You can provide a list of Field objects or a
> list of colnames in "table.field" format and it will return a Rows object
> for you. It's almost too easy!
>
> rows=db.executesql("select id,code,name from lsc",
> colnames=['lsc.id','lsc.code','lsc.name'])
>
>
> -- Joe
>
> On Tuesday, May 20, 2014 7:26:24 AM UTC-7, Richard wrote:
>
>> 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 <joe.ba...@gmail.com>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 web2py+un...@googlegroups.com.
>>>
>>> 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 web2py+unsubscr...@googlegroups.com.
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
