i have a weird behavior with this select:
<select id="porParteConFiltro" resultMap="tesisTO"
parameterClass = "mx.gob.scjn.iuscommon.TO.PartesTO">
select A.Parte, A.IUS, A.Rubro, B.descEpoca,
C.descInst sala, A.Tesis, A.LocAbr, A.ConsecIndx,
A.ta_tj, A.tpoTesis, D.imageWeb, D.descripcion descTpoTesis, D.imageOther
from Tesis A, cepocas B, cinsts C, ctpoTesis D
where parte = #parte#
AND #filterBy# = #filterValue#
AND A.epoca = B.idEpoca
AND A.sala = C.idInst
AND A.tpoTesis = D.id
order by #orderBy# #orderType#
</select>
If i put tpoTesis instead filterBy i got the results i want... it seams like
iBatis is putting 'tpoTesis' (with apostrophes) instead the value
Greetings
Carlos de Luna Sáenz
____________________________________________________________________________________
¡Capacidad ilimitada de almacenamiento en tu correo!
No te preocupes más por el espacio de tu cuenta con Correo Yahoo!:
http://correo.espanol.yahoo.com/
