SQL doesn't seem to match complex qualifiers
SQL doesn't seem to match complex qualifiers
- Subject: SQL doesn't seem to match complex qualifiers
- From: Joe Moreno <email@hidden>
- Date: Fri, 06 Feb 2009 16:06:09 -0800
| 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden