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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
