Greet! thx a lot.

On 4/15/06, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Sat, Apr 15, 2006 at 02:07:57AM +0800, Henotii wrote:
> > How can i implement sql like
> > "select top 10 * from table order by some_columns"
> > in SQLObject?
>
> MyTable.select(orderBy=MyTable.q.some_column)[:10]
>
>    And no, this does not mean "select all, then cut top 10". SelectResults,
> the result of .select() call does intelligent things with indices.
>    SQLObject supports "SELECT TOP" for MSSQL.
>
> Oleg.
> --
>      Oleg Broytmann            http://phd.pp.ru/            [EMAIL PROTECTED]
>            Programmers don't die, they just GOSUB without RETURN.
>
>
> -------------------------------------------------------
> 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
> _______________________________________________
> sqlobject-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>


--
Wenjie

Reply via email to