• 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
Re: qualifier with NOT
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: qualifier with NOT


  • Subject: Re: qualifier with NOT
  • From: Theodore Petrosky <email@hidden>
  • Date: Mon, 19 Sep 2011 13:52:34 -0700 (PDT)

Great thanks, but how to add the wildcard character?

_grossBillingList = jobinv.fetchJobInvs(theEC, jobinv.GLPER.eq(glPeriod). and (ERXQ.not(jobinv.JOBNUM.likeInsensitive("SP%"))), null);

this query works great:
select SUM(invamt) "InvTotal" from job_inv where glper = '201108' and jobnum not like 'SP%';

I must be missing some escaping of the character.

Ted


--- On Mon, 9/19/11, Kieran Kelleher <email@hidden> wrote:

> From: Kieran Kelleher <email@hidden>
> Subject: Re: qualifier with NOT
> To: "Theodore Petrosky" <email@hidden>
> Cc: email@hidden
> Date: Monday, September 19, 2011, 1:47 PM
> One (of probably multiple) way(s)
> is:
>
> jobinv.GLPER.eq(glPeriod). and ( ERXQ.not(
> jobinv.JOBNUM.ilike("SP Conv") ) )
>
> On Sep 19, 2011, at 12:21 PM, Theodore Petrosky wrote:
>
> > OK.. I am giving up and asking
> >
> > I need to .not() part of a qualifier
> >
> > jobinv.GLPER.eq(glPeriod). and
> (jobinv.JOBNUM.ilike("SP Conv"))
> >
> > but I want isNOTlike
> >
> > in testing the SQL I used:
> >
> > SELECT clcode, invamt "InvTotal", jobnum, jobinvnum
> FROM job_inv WHERE glper = '201108' AND jobnum NOT LIKE 'SP
> CONV%'
> >
> > I don't understand how to use not() in the above
> qualifier.
> >
> > Ted
> > _______________________________________________
> > 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
>
>
 _______________________________________________
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: qualifier with NOT
      • From: Kieran Kelleher <email@hidden>
    • Re: qualifier with NOT
      • From: Johann Werner <email@hidden>
References: 
 >Re: qualifier with NOT (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Re: Adding WOLips framework = exception at startup
  • Next by Date: ERXReCaptcha & SSL
  • Previous by thread: Re: qualifier with NOT
  • Next by thread: Re: qualifier with NOT
  • Index(es):
    • Date
    • Thread