ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kris Barnhoorn" <k...@biassweb.be>
Subject RE: sql fragment as parameter
Date Thu, 30 Dec 2004 17:00:22 GMT
Yes. In my example this is pojos.language.
-----Oorspronkelijk bericht-----
Van: roberto [mailto:roberto@theaegis.org] 
Verzonden: donderdag 30 december 2004 17:49
Aan: ibatis-user-java@incubator.apache.org
Onderwerp: RE: sql fragment as parameter
What is ld.language?  Is that in the 'pojos' table with the dot
-----Original Message-----
From: Kris Barnhoorn [mailto:kris@biassweb.be] 
Sent: Thursday, December 30, 2004 11:54 AM
To: ibatis-user-java@incubator.apache.org
Subject: sql fragment as parameter
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
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"
            SELECT *
            FROM `pojos` 
                  <isNotEmpty property="whereCriteriaString">
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:
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,

View raw message