find method with LIKE

tads · **Posted:** Mon Dec 15, 2003 12:26 pm

Hi all...

I

baliukas · **Posted:** Mon Dec 15, 2003 12:47 pm

Why do you need "where" twice ?

tads · **Posted:** Mon Dec 15, 2003 12:49 pm

In this message it is wrong, but into java code, is correct:

Code:

query = "select o from Order o join o.items item 
where upper(item.naUser) like upper ( % ? % )"; 

baliukas · **Posted:** Mon Dec 15, 2003 12:49 pm

try this :
query = "select o from Order o join o.items item
where upper(item.naUser) like upper ( ? )";

Object[] obj = new Object[1]; // only example
Type[] tp = new Type[1]; // only example

obj[0] = "%" + stringNaUser + "%";
tp[0] = Hibernate.STRING

....

tads · **Posted:** Mon Dec 15, 2003 2:00 pm

Very good!!!!

thanks for your help!!!

[]