On Fri, May 04, 2007 at 02:47:49PM -0400, Thierry Lam wrote:
> SELECT distinct name FROM users
SQLObject instances ("tables") are about running queries like
SELECT * FROM users
There is no way to select just a column using User class. You can run
User.select(distinct=True), it gives you
SELECT DISTINCT * FROM users
But that's probably not what you want.
You can use sqlbuilder.Select() but it will support "distinct" option
only in SQLObject 0.10 (you may download an alpha tarball to look and try).
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 DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
