Re: qualifier with NOT
Re: qualifier with NOT
- Subject: Re: qualifier with NOT
- From: Theodore Petrosky <email@hidden>
- Date: Mon, 19 Sep 2011 19:14:29 -0700 (PDT)
that's beautiful. in the sql the * turns into %.
Thanks, I don't know where that was documented.
Ted
--- On Mon, 9/19/11, Johann Werner <email@hidden> wrote:
> From: Johann Werner <email@hidden>
> Subject: Re: qualifier with NOT
> To: "Theodore Petrosky" <email@hidden>
> Cc: "WebObjects Development" <email@hidden>
> Date: Monday, September 19, 2011, 6:39 PM
>
> Am 19.09.2011 um 22:52 schrieb Theodore Petrosky:
>
> > 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);
>
> I think you should use '*' instead of '%' in those
> qualifiers ->
> ERXQ.not(jobinv.JOBNUM.likeInsensitive("SP*"))
>
> >
> > 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
> >
>
>
_______________________________________________
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