The following statement always complain bad grammar. I
can't see where it's the problem, neighter can I see
the generated SQL statement. Please help.
<statement id="getUserProfileList"
resultMap="userProfile"
parameterClass="java.util.Map"><![CDATA[
SELECT c.First_Name, c.Surname, e.Email_Address
FROM Customer c, Email_Address e
where c.user_id = e.user_id
<dynamic>
<isNotNull prepend="AND" property="userName">
lower(trim(c.user_name))
$accountNameOperator$ #userName#
</isNotNull>
</dynamic>
ORDER BY $sortColumn$ $sortDirection$
]]></statement>
yihuayishijie yishuyichunqiu
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
