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 protected]> wrote: > From: Johann Werner <[email protected]> > Subject: Re: qualifier with NOT > To: "Theodore Petrosky" <[email protected]> > Cc: "WebObjects Development" <[email protected]> > 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 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/jw%40oyosys.de > > > > 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]
