Re: EOF & DISTINCT/ORDER BY problem - need help...

Anjo Krank <[email protected]> Thu, 27 Jan 2005 19:27:34 +0100

Newsgroups	gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof
Message-ID	<[email protected]>

Am 27.01.2005 um 18:50 schrieb Simeon Johnston:

> Even more tantalizing comment from a plugin class file --
>         // AK: using DISTINCT with ORDER BY UPPER(foo) is an error if 
> it is not also present in the columns list...
>         // This implementation sucks, but should be good enough for 
> the normal case
>
> Yep... looks like the problem I have.

Yes, it is. And very annoying, too.

> Guess I'll be switching to the Wonder plugin (CVS version).

You also could put that code (or similar code) in a DBC delegate... so 
you wouldn't need a specific plugin.

Cheers, Anjo