Sorry forgot something in my former post. See below

On Sun, Apr 6, 2008 at 2:29 PM, Frank Wagner <frank.wagner@nofusion.de> wrote:
Hi Daniel,

it will not be possible to achieve this with the regular SQLObject-classes. All you can do is something like this:



Yoursqlobject._connection.queryAll("select distinct ...") # hardcoded sql


or, to maintain more flexibility:

conn = Yoursqlobject._connection
conn.queryAll(conn.sqlrepr(Select(items=Yoursqlobject.q.column)))

this won´t include DISTINCT in the sql. this will:
 
results = conn.queryAll(conn.sqlrepr(Select(items=Yoursqlobject.q.column, distinct=True)))




HTH.

KR,
Frank



On Sun, Apr 6, 2008 at 7:55 AM, Daniel Fetchinson <fetchinson@googlemail.com> wrote:
Hi folks,

Is it possible to select only 1 column out of a table and not the
whole record? More specifically, what I really need is the following:

SELECT DISTINCT column FROM table;

The point is that I only need DISTINCT values and if I can't select 1
column only then I can't use DISTINCT because generally full records
are never the same but the value in 'column' might be repeated. So I
would need to select everything and filter through the data in python
which would be a huge performance hit.

Cheers,
Daniel

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss