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
