Re: Fetch Spec Problem - using distict
Re: Fetch Spec Problem - using distict
- Subject: Re: Fetch Spec Problem - using distict
- From: Jonathan Rochkind <email@hidden>
- Date: Tue, 12 Aug 2003 16:16:50 -0500
At 09:51 PM 8/12/2003 +0100, Jonathan Fleming wrote:
I've got -EOAdaptorDebugEnabled=true already enabled but not
-DEOAdaptorDebugEnabled=true
What's the difference or is this a typo
Well, yours is a typo. :) There are two ways to set properties for your WO
application:
1) Old-style, WO-specific: "-KeyName value"
2) New style, Java properties system: "-DKeyName=value"
You'll note that the first one has a space instead of an =, while the
second one puts a 'D' in front of the key name. The one you've given as an
example is neither style, and won't work. Either of the other two will.
Now you can see exactly what SQL EOF is generating. Then you need to
understand, perhaps by looking in the MS SQL Server 2000 reference,
I was hoping to avoid this as their manuals are pretty big and jumbled,
but looks as if i'll have to :^/
Maybe someone else knows the answer for you; I just don't, sorry.
Or you could just chuck the whole thing, and forget the distinct.
Instead, fetch all the rows in, but then unique them in memory. One easy
way to do that is:
Well, at least I have a workaround option if I get stuck.
It's what I've done in similar situations.
Good luck,
--Jonathan
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.