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 ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
