Hi,
I have this sql map:
...
<dynamic prepend="union">
   <isNotNull property="queryFulltext" removeFirstPrepend="false">

      select theses.id as id,
      ...
      ...
      where theses_documents.index @@ to_tsquery('cs', #queryFulltext#)

      <isNotNull property="categoryId" prepend="and">
         theses_categories.id = #categoryId#
      </isNotNull>
   </isNotNull>
</dynamic>
...

This sql map throws me an sytax error.
When I check SQL code ibatis has generated, i can see, that last prepend
(AND) is not generated.So the query looks like:

where theses_documents.index @@ to_tsquery('cs', #queryFulltext#)    
[HERE SHOULD BE AND, BUT ISN'T]        theses_categories.id = #categoryId#

Can somebody show me a direction? I have read carefuly the definitions in
Ibatis in action (when the prepends are included and when not), but can't
understant why this happens. Thank you.
-- 
View this message in context: 
http://www.nabble.com/dynamic-prepend-problem-tp22790132p22790132.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Reply via email to