> > 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)))Hi Frank, the hard coded query of course works but I'd like to have something go through sqlobject. The Select( ) actually does the trick of selecting only 1 column, thanks! But it does not accept 'distinct' as a keyword argument, I wonder why. ------------------------------------------------------------------------- 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
