RE: Problems with Dynamic SQL

2008-10-22 Thread Yamil Bracho
Well, I change my mapping to SELECT co_afiliacion, nu_rif, nb_empresa, cce.solicitud_afiliacion.co_sector, cce.sector.nb_sector, cce.solicitud_afiliacion.co_

RE: Problems with Dynamic SQL

2008-10-22 Thread Yamil Bracho
Date: Wed, 22 Oct 2008 10:34:59 -0600 > From: [EMAIL PROTECTED] > To: user-java@ibatis.apache.org > Subject: Re: Problems with Dynamic SQL > > If you put xml tags in a cdata section, they are ignored...that's the > point of the cdata section... > > Larry > >

Re: Problems with Dynamic SQL

2008-10-22 Thread Larry Meadors
If you put xml tags in a cdata section, they are ignored...that's the point of the cdata section... Larry On Wed, Oct 22, 2008 at 10:19 AM, Yamil Bracho <[EMAIL PROTECTED]> wrote: > Hi. > I have this mapping > > parameterClass="java.util.HashMap" > resultMap="mapSolA

Problems with Dynamic SQL

2008-10-22 Thread Yamil Bracho
Hi. I have this mapping Where nu_rif is a String field and rifList is an array o String. In java I did: Map parameters = new HashMap(); parameters.put("codigoBanco", codigoBanco); parameters.put("rifList", rifList.split(","));

RE: problems with dynamic sql

2006-07-27 Thread Celaya, Tina \(GE Indust, ConsInd\)
Thank you very much, i´ll try ir with the iterate.   -Original Message-From: Clinton Begin [mailto:[EMAIL PROTECTED]Sent: Jueves, 27 de Julio de 2006 04:02 p.m.To: user-java@ibatis.apache.orgSubject: Re: problems with dynamic sqlYep. You want the element for dynamic quer

Re: problems with dynamic sql

2006-07-27 Thread Clinton Begin
Yep. You want the element for dynamic queries.  It will help you avoid the risks of $substring$ replacement.  The months value in the map should be a List or array[] of integers.  The year shoudl be an integer or a string, depending on how your database is designed. Cheers, ClintonOn 7/27/06, Cela

Re: problems with dynamic sql

2006-07-27 Thread Larry Meadors
Look at the iterate stuff. Larry On 7/27/06, Celaya, Tina (GE Indust, ConsInd) <[EMAIL PROTECTED]> wrote: I want to put somthing like this in de query moths in (1,2,3,4,5,6) and I tried using month in ($list$) and list have integers 1,2,3,4,5,6 but it doesnt work, i have an error that says i

problems with dynamic sql

2006-07-27 Thread Celaya, Tina \(GE Indust, ConsInd\)
I want to put somthing like this in de query moths in (1,2,3,4,5,6) and I tried using month in ($list$) and list have integers 1,2,3,4,5,6 but it doesnt work, i have an error that says invalid colum '1,2,3,4,5,6' and i dont know how to solve this so i can have this query select * from table wher