WO 4.0, Oracle 8.0, Java, NT
Hey,
Does anyone know how to turn the following SQL statement into a
Qualifier? The Parser really
doesn't like the "trunc((sysdate-30), 'MONTH')" command.
select * from by_channel where oc_Subscriber_Id=2 AND
SUBSCRIBER_DATE=trunc((sysdate-30), 'MONTH')
I tried this:
aQualifier = EOQualifier.qualifierWithQualifierFormat("ocSubscriberId="
+ ocSubscriberId + " AND subscriberDate=trunc((sysdate-30), 'MONTH')" ,
argumentsArray);
But it would crash when it tried to parse the Qualifier.
I also tried sending in an NSGregorianDate but the NSParser didn't seem
to like any
format I tried with it. Againg the NSParser would die on the first '-'
it saw.
--- Darrell
--
--------------------------------------------
[EMAIL PROTECTED]
