[ http://issues.apache.org/jira/browse/IBATIS-315?page=all ] Jeff Butler closed IBATIS-315: ------------------------------
Resolution: Invalid This is functioing as designed. Please use the mailing lists for support questions. > the first dynamic prepend seems to be required > ---------------------------------------------- > > Key: IBATIS-315 > URL: http://issues.apache.org/jira/browse/IBATIS-315 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.7 > Environment: Windows XP SP2, JDK 1.4.2 > Reporter: Doug Duong > Priority: Minor > > I have a statement defined as below: > select ... > from ... > <dynamic prepend="where"> > <isNotNull property="prop1"> > text1 > </isNotNull> > <isNotNull property="prop2" prepend="and"> > text2 > </isNotNull> > </dynamic> > If both prop1, prop2 are not null, it produces a sql like this: > select ... > from ... > where > text1 > text2 > => Although a prepend "and" is specified for "prop2", it is not added before > "text2". However, if I specify a prepend "and" for "prop1", then the sql is > produced correctly: an "and" is added before "text2". Therefore, I say the > first prepend must be always specified. Am I right? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira