you can trick it like this if you want. suppose your table has a column "id" in it:
s = select(["SQL_CALC_FOUND_ROWS id", sometable], from_obj=[sometable]) that or just use text("select SQL_CALC_FOUND_ROWS, foo, bar, lala from sometable") ill look into adding a prefix() construct for this kind of thing. On Mar 7, 2007, at 3:32 AM, [EMAIL PROTECTED] wrote: > Hi everyone. > > How can I specify parameter SQL_CALC_FOUND_ROWS in SELECT query (I'm > using mysql 5.0)? Is there any (engine-independant) solution to > determine, how many rows where matched with whereclauses in complex > select query? ResultProxy.rowcount holds the number of returned rows, > limited by the LIMIT statement, it is not what I need. > > Thanks, sorry for my terrible english. > > ___ > > > Всем привет. > Как я могу передать select-запросу > параметр SQL_CALC_FOUND_ROWS > (использую mysql 5.0)? Есть может какой-то > другой (быть может, даже > движково-независимый) способ > определения, сколько строк > удовлетворяет > условиям отбора в сложном запросе? В > ResultProxy.rowcount лежит число > отобранных записей, не более > параметра LIMIT, это совсем не то, что > мне нужно. > > Спасибо, прошу прощения за свой > бестолковый анлгийский. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---