I'm trying to execute the following EJB-QL query: SELECT DISTINCT OBJECT(p) FROM Product AS p WHERE LOCATE(p.productId,?1) > -1 OR LOCATE(p.name,?1) > -1 OR LOCATE(p.description,?1) > -1
Shouldn't this work like the following SQL query: SELECT * FROM Product WHERE p.productId like ?1 OR p.name LIKE ?1 OR p.description LIKE ?1 If not, does anyone knows how to use LIKE in EJB-QL with parameters? ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
