select distinct

From: tnaki..ofthome.net
Date: Mon Mar 21 2005 - 09:45:25 EST

Next message: Andrus Adamchik: "Re: Cayenne 1.2M3 released"

Previous message: Jürgen Saar: "Re: orderby on tomany relation"
Next in thread: Cris Daniluk: "RE: select distinct"
Reply: Cris Daniluk: "RE: select distinct"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi everyone,

how would you go about extracting a list of distinct values of a single
attribute from one table? This is not a normalized table and I'm not in
a position to normalize it so bare with me, please.
Obviously, a trivial view in the database solves the problem, but I'd
like to keep code in the application when I can.
Do I run a raw query from the application? Can I model a view containing
the distinct values in the modeler?

Tomislav

Next message: Andrus Adamchik: "Re: Cayenne 1.2M3 released"
Previous message: Jürgen Saar: "Re: orderby on tomany relation"
Next in thread: Cris Daniluk: "RE: select distinct"
Reply: Cris Daniluk: "RE: select distinct"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon Mar 21 2005 - 09:42:42 EST