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/archive%40mail-archive.com
This email sent to [email protected]
