Re: [web2py] Re: count of reference usage
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#count,-isempty,-delete,-update On Thu, Nov 14, 2013 at 4:04 AM, webpypy ad...@aqar-riyadh.com wrote: Thank you , Massimo. Would please write down the statement for calculating the count of Things for every person? instead of for row in persons_and_things.select(): print row.person.name, row.thing.name Alex Boat Alex Chair Bob Shoes Curt Boat I would like to get Alex 2 Bob 1 Curt 1 Regards, Ashraf -- 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/groups/opt_out. -- 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/groups/opt_out.
Re: [web2py] Re: count of reference usage
Thank you , Massimo viniciusban , Would please write down the statement for calculating the count of Things for every person? instead of for row in persons_and_things.select(): print row.person.name, row.thing.name Alex Boat Alex Chair Bob Shoes Curt Boat I would like to get Alex 2 Bob 1 Curt 1 Regards, Ashraf -- 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/groups/opt_out.
[web2py] Re: count of reference usage
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=db.person.id.count%28%29 On Wednesday, 13 November 2013 19:21:31 UTC-6, webpypy wrote: Hi, I have three tables ( emp , dept ) and (many to many). How to get (for each dept), how many times each dept is referenced? deptnumber of occurrences -- . . . Regards, Ashraf -- 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/groups/opt_out.
[web2py] Re: count of reference usage
Thank you , Massimo. Would please write down the statement for calculating the count of Things for every person? instead of for row in persons_and_things.select(): print row.person.name, row.thing.name Alex Boat Alex Chair Bob Shoes Curt Boat I would like to get Alex 2 Bob 1 Curt 1 Regards, Ashraf -- 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/groups/opt_out.