Hi I'm trying to get the count of records to be returned in a query using:
db(query).count() Adding complexity to the situation is that query may sometimes be over multiple tables with need a left clause added. When selecting records you do this by passing the left= parameter inside the .select(). But, you can't pass anything into the .count() method. Has anyone found an efficient way to get a .count() when a left join is in use? -Jim (cross-posting to py4web as well) -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/d71ce814-06a0-4e14-8661-7c75ea1206eeo%40googlegroups.com.