* Regards, Kieran. (Sent from my iPhone)
On Sep 19, 2011, at 4:52 PM, Theodore Petrosky <[email protected]> wrote: > 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 protected]> wrote: > >> From: Kieran Kelleher <[email protected]> >> Subject: Re: qualifier with NOT >> To: "Theodore Petrosky" <[email protected]> >> Cc: [email protected] >> 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 protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >>> >>> This email sent to [email protected] >> >> _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
