|
Yes.
In my example this is pojos.language. Kris. -----Oorspronkelijk bericht----- What is ld.language? Is that in the
‘pojos’ table with the dot notation? Roberto -----Original
Message----- 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. |
- sql fragment as parameter Kris Barnhoorn
- RE: sql fragment as parameter roberto
- RE: sql fragment as parameter Kris Barnhoorn
- RE: sql fragment as parameter Daniel H. F. e Silva
- Re: sql fragment as parameter Brandon Goodin
- RE: sql fragment as parameter Severtson, Scott \(Associate\)
- RE: sql fragment as parameter Kris Barnhoorn
