HI, I hope someone can help me with a frustrating problem that is similar to another thread running but related to dynamic QL
I cannot seem to get a case insensitive like search to work with Dynamic-QL. The same query works fine with a normal @jboss.query method. Here is the Dynamic QL; "SELECT OBJECT(m) FROM MemberBean AS m WHERE m.organisation.organisationId = ?1 AND (LCASE(m.secondName) LIKE LCASE(?2)) " For example, if the database countains Alan Younger and ?2 is 'younger' then the query returns a result. However, if ?2 is 'young' then no results are returned. I dont understand what is wrong. Is there any reason why a query would not work in Dynamic QL but would work in non dynamic QL? Hope you can help, Richard View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846131#3846131 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846131 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user