I'm trying to build a select that uses a union of two sql statements
both using the between operator in SQL to check for a date between two
values. I can't get it to work, I keep getting sax exception saying
that I'm missing the end </dynamic> tag. I've checked the whole file
and I've got balanced tags, so I don't get it. I'm attaching the
XML/SQL and I'm hoping that someone can set me straight.
<select id="maxAllocated"
resultClass="com.caiso.irr.db.ibatis.DaoImpl$InlineFloat">
select
max(value) as value
from (
select
max( somevalue ) as value
from
table_1
<dynamic prepend="WHERE">
<isNotNull property="startDate">
<isNotNull prepend="AND" property="endDate">
opr_dt between #startDate# and ( #endDate# - 1/86400 )
</isNotNull>
</isNotNull>
</dynamic>
union
select
max( somevalue ) as value
from
table_2
<dynamic prepend="WHERE">
<isNotNull property="startDate">
<isNotNull prepend="AND" property="endDate">
opr_dt between #startDate# and ( #endDate# - 1/86400 )
</isNotNull>
</isNotNull>
</dynamic>
)
</select>
--mikej
-=-----
mike jackson
[EMAIL PROTECTED]
Character Density, n.:
The number of very weird people in the office.
