Ibatis problem about dao xml

[erakhman]

Hello...

how to create code for searching process in ibatis dao xml. i have try code like this, but it can't work. i use dbms mysql, thanks for your help.... :)

<select id="searchEmployee" parameterClass="varchar" resultMap="EmployeeResult">
		select * from employee 
		where first_name = #name:varchar#,  or last_name = #name:varchar#
	</select>

[travishein]

is it that it is returning no rows, or that it is failing to map the results to the resultMap?

[cmaj135]

first,you must write the SQL correctly,but i find the extra comma in your ibatis sql,see below
#name:varchar#, or last_name = #name:varchar#