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

The UPPER is generated by EOF because it's sorting caseInsensitively 
(eomodeler fetch spec -> Sort Orderings -> little box thingy for case 
's' or 'i').
This type of fetch spec is used in many other places in our eomodel 
file.  We also use a lot of caseInsensitive searches within our app, 
though I don't know of any that are distinct (though it could happen).
Besides that I also need to support both PostgreSQL and FrontBase (and 
possibly more dbms's in the future), so I'd rather not add things 
specifically for any one DBMS.
I was actually looking at adjusting the PlugIn to fix this.  If the 
Wonder plug in will do this I have no problem switching.

I am curious about the licensing of the Wonder plugin.  I don't see any 
license file with the source.

sim

On Jan 27, 2005, at 11:05 AM, Arturo Perez wrote:

> Simeon Johnston wrote:
>
>> This sql was generated by EOF -
>> SELECT DISTINCT t0.A_BOOLEAN, t0.A_VARCHAR, t0.THE_PK, t0.LABEL, 
>> t0.TYPE FROM THE_STUPID_TABLE t0 WHERE (t0.A_BOOLEAN = true AND 
>> t0.TYPE = 2) ORDER BY UPPER(t0.LABEL) ASC
>
> I'm wondering how you got that UPPER in there?
>
>> Using WO 5.2.3 w/ PostgreSQL 7.4.6 & jdbc driver w/ Hexdreams plugin.
>
> The project wonder plugin will generate more pgSQL-compliant SQL.  
> That being said, I wonder if putting a derived column of UPPER(LABEL) 
> will help you out?
>
> -arturo
>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>