|
Hello, I’m
having some trouble while using <isNotEmpty/> node inside <select/> Please take a
look at below select statement. <select
id="search"
parameterClass="java.util.HashMap"
resultClass="java.util.HashMap">
select ConsultantId, BlackListed, FirstName, LastName, HomeTelephone,
EmailAddress, InterviewGrade, TotalYrsOfExp from Consultant where
<isNotEmpty property="FirstName">FirstName like
#FirstName#</isNotEmpty>
<isNotEmpty property="LastName"
prepend=" and
">LastName like #LastName#</isNotEmpty>
<isNotEmpty property="ActiveInactive"
prepend=" and
">ActiveInactive like
#ActiveInactive#</isNotEmpty>
order by FirstName, LastName
</select> The problem with
this stmt is if only ActiveInactive is keyed in, the select stmt is resolved
like below – select ConsultantId, BlackListed, FirstName, LastName,
HomeTelephone, EmailAddress, InterviewGrade, TotalYrsOfExp from Consultant
where
and ActiveInactive like ?
order by FirstName, LastName ‘and’
is added in the stmt which makes it invalid query. How do I adjust the
<isNotEmpty/> tags inside <select/> so that it will work for any
combination? Help, please ! ~ Nilesh |
- RE: Qns abt using <isNotEmpty/> inside <select/>... Nilesh Bhattad
- RE: Qns abt using <isNotEmpty/> inside <selec... Chen, Tim
- RE: Qns abt using <isNotEmpty/> inside <s... Nilesh Bhattad
