roberto80

Hi all!
I have this where clause:
((VALIDO_DAL IS NULL AND VALIDO_AL IS NULL) OR (VALIDO_DAL IS NULL AND now <= VALIDO_AL) OR (VALIDO_AL IS NULL AND now >= VALIDO_DAL) OR (now BETWEEN VALIDO_DAL AND VALIDO_AL)) AND gruppo LIKE GRUPPO_UTENTE AND categoria LIKE CATEGORIA AND tipoProd LIKE TIPO_PROD AND articolo LIKE ARTICOLO
i don't know how i have to write in EJB Extension Editor to run this query.
Roberto

Hi
I have this problem, i have to build a new finder called findByAccount(String account,String cliente) but i'm not able to build the where clause. I write this:
T1.ACCOUNT = ?1 AND T1.CLIENTE = ?2
but when server run i have this error:
RemoteException occurred in server thread; nested exception is: com.ibm.ejs.persistence.EJSPersistenceException: find failed:; nested exception is: com.jnetdirect.jsql.p: Line 1: Incorrect syntax near '1'.
Roberto