RE: sql fragment as parameter

[roberto]

What is ld.language?  Is that in the ‘pojos’ table with the dot notation?   Roberto     -----Original Message----- From: Kris Barnhoorn [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 11:54 AM To: ibatis-user-java@incubator.apache.org Subject: sql fragment as parameter   Hi,   First I’d like to thank the developers for this great tool.   I’d like to insert an sql fragment as a parameter to an sql select statement. what i do is generate some sql in a class which is used as parameterClass in the xml file   the whereCriteriaString constructs the string based criteria selectable on the webpage. Users can choose the make more than one “filter”   filter:  property | value | (AND | OR) add filter     So I simply did this:         <select id="getPojos" parameterClass="org.foo.SqlQuery"             resultClass="org.foo.Pojo">             SELECT *             FROM `pojos`             WHERE             <dynamic>                   <isNotEmpty property="whereCriteriaString">                         #whereCriteriaString#                   </isNotEmpty>             </dynamic>       </select>   What generates 218 [main] DEBUG sql.PreparedStatement  - {pstm-100004} PreparedStatement: SELECT * FROM `pojos` WHERE ? 218 [main] DEBUG sql.PreparedStatement  - {pstm-100004} PreparedStatement: Parameters: [(ld.language  =  'en' ) ] 218 [main] DEBUG sql.PreparedStatement  - {pstm-100004} Types: [java.lang.String]   This doesn’t work   So my question is can iBatis generate this?   218 [main] DEBUG sql.PreparedStatement  - {pstm-100004} PreparedStatement: SELECT * FROM `pojos` WHERE (ld.language  =  'en' )       I looked at <iterate>, but I don’t think I can emulate a similar behaviour with it.     Thank you,   Kris.