ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lihui Pang <lihui_p...@yahoo.com>
Subject question on dynamic query. Thanks for help.
Date Sat, 15 Apr 2006 01:03:41 GMT
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 

Mime
View raw message