theres a full assortment of count() functions, both on selectable query objects and mappers...seems like a little more docs needed -
sql: mytable.count() mytable.count(mytable.c.col1==5) select([func.count(mytable.c.col1)], mytable.c.col1==5) mappers: mapper.count(MyObj.c.col1==5) mapper.count_by(name='fred') Jonathan Hayward http://JonathansCorner.com wrote: > Is there a good (or a bad--generate a cusor, go through and count each > one, > regenerate cursor) way to get an exact or approximate count on the number > of > results in a result set? > > -- > ++ Jonathan Hayward, [EMAIL PROTECTED] > ** To see an award-winning website with stories, essays, artwork, > ** games, and a four-dimensional maze, why not visit my home page? > ** All of this is waiting for you at http://JonathansCorner.com > > ** If you'd like a Google Mail (gmail.com) account, please tell me! > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
