Joe,
Can you build this manually in code with qualifier objects? I would
try that and see if the results are the same...
Ken
On Feb 6, 2009, at 7:06 PM, Joe Moreno wrote:
Hi all,
It seems my graphical fetch spec is looking different when turned
into SQL.
I'm using the following graphical fetch spec:
(includeExcludeType = "0")
or
((includeExcludeType = "1" and ((not (excludeList like $lastName))
or (not (excludeList like $firstName))))) or
((includeExcludeType = "2" and (includeList like $lastName or
includeList like $firstName)))
But, for some reason, the order of importance (i.e. parenthesis) in
the SQL seems to be getting messed up. Here's what I'm seeing being
sent to the database:
(
t0.INCLUDE_EXCLUDE_TYPE = ? OR
(
t0.INCLUDE_EXCLUDE_TYPE = ? AND
(
not
(
t0.EXCLUDE_LIST like ?
)
OR not
(
t0.EXCLUDE_LIST like ?
)
OR
(
t0.INCLUDE_EXCLUDE_TYPE = ? AND
(
t0.INCLUDE_LIST like ? OR
t0.INCLUDE_LIST like ?
)
)
)
)
)
I'm not sure what I'm doing wrong. The last OR should not be
"indented".
Thanks,
Joe
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com
This email sent to kenli...@anderhome.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
