Hi,

Is it possible to use "distinct" with sqlbuilder? I would like to select just one column, but only distinct values, like so:

myselect = conn.sqlrepr(Select(Roster.q.maladyCode, distinct=True))
maladies = conn.queryAll(myselect)

However, I get an error, saying "distinct" is invalid key word.

Am I doing something wrong? Or is there some other way of doing this?

Thanks!

David Geller


-------------------------------------------------------
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

Reply via email to