I'm using SQLObject 0.7.0 and I'm having lots of trouble retrieve a list
of distinct columns from my table. What is the equivalent of the
following in SQLObject?
Table: users
Columns: id, name, age
SELECT distinct name FROM users
The only way I can do the above is the following which uses raw sql
statement:
c = users._connection
return c.queryAll('SELECT distinct name FROM users')
Is there an alternative way to do the above?
Thierry
-------------------------------------------------------------------------
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss