SQLTemplate - multiple statements

[Dave Merrin]

Hi,

is it possible to have multiple sql statments in the one SQLTemplate?

e.g.

   <query name="PurgeItemByRootNodeId" factory="org.apache.cayenne.map.SQLTemplateBuilder" 
root="data-map" root-name="Untitled">
       <property name="cayenne.GenericSelectQuery.fetchingDataRows" 
value="true"/>
       <sql>
           <![CDATA[
           DELETE item
           FROM item, item_node
           WHERE item.item_id = item_node.item_id
           AND item_node.item_node_id = $root_node_id;
           ]]>
       </sql>
       <sql>
           <![CDATA[
           DELETE
           FROM item_node
           WHERE item_node.item_node_id = $root_node_id;
           ]]>
       </sql>
   </query>

Cheers,

Dave