• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
SQL doesn't seem to match complex qualifiers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: SQL doesn't seem to match complex qualifiers
      • From: Ken Anderson <email@hidden>
  • Prev by Date: Re: Entity Modeller - Setting Up Many-to-Many Relationships: Link Entities(?)
  • Next by Date: Error running app in dist
  • Previous by thread: Re: WO5.4.x resource manager bytesForResourceNamed bottleneck
  • Next by thread: Re: SQL doesn't seem to match complex qualifiers
  • Index(es):
    • Date
    • Thread