[web2py] Re: what is syntax for recursive join?

2016-06-14 Thread Alex Glaros
Niphlod, good insight regarding managing response times. Thanks for pointing the right direction. Alex -- 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) ---

[web2py] Re: what is syntax for recursive join?

2016-06-13 Thread Niphlod
once you establish how a record gets tagged as "it has no children" you break from the loop. That being said DON'T use recursive selects for an adjacency listyou don't want to loose control over how many queries you launch. If you need, rebuild the structure in python from a single select,