Sorry forgot something in my former post. See below
On Sun, Apr 6, 2008 at 2:29 PM, Frank Wagner <[EMAIL PROTECTED]>
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 <
> [EMAIL PROTECTED]> 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
> >
>
>
-------------------------------------------------------------------------
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
