Javier - you certainly can do this. Look in the developer's guide under
complex properties in result maps. It's on page 25 in my printed copy.
your result map for the main select will have a row like this:
<result property="category" column="PRD_CAT_ID" select="getCategory"
PRD_CAT_ID refers to the column from the first select you will use as
the parameter for the second query.
The select parameter refers to the statement name.
Hope this is helpful!
Diran
Javier Leyba wrote:
Hi
I've a sqlmap to a class that is filled with data from a select but
one field should be getted from another table and then I wonder if is
posible to make the second select in the same sqlmap file and return
data filled.
My sqlMap is
-----------
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd";>
<sqlMap namespace="Participes">
<typeAlias alias="participes"
type="org.jl.meriden.listados.dao.Participes" />
<select id="selectParticipes"
resultClass="participes">
<![CDATA[
select
E10CTA as nroCuenta,
E10TSU as suscriptas,
E10TRE as reembolsadas,
E10TIT as saldoParticipe,
E10TPG as saldoPignorado,
E10PSU as saldoSuscripto,
E10PRE as saldoRembolsado,
E10PCM as saldoCosteMedio
from dpicfic.E10PI
where E01PI.E01FBA <> 0
]]>
</select>
</sqlMap>
------------
and I need to add another field that comes from another select that
receives E10CTA as parameter.
Thanks in advance
--
Javier Leyba
Barcelona - Spain
http://blog.leyba.com.ar
