Re: qualifier with NOT
Re: qualifier with NOT
- Subject: Re: qualifier with NOT
- From: Kieran Kelleher <email@hidden>
- Date: Mon, 19 Sep 2011 13:47:39 -0400
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