Re: help problem with select request using 'in' where clause

[jeb001]

Hi,

Thanks for your help.. but something still drives me crazy..

It seems that I sould pass a "java.util.Map" object and not a
"java.util.List" in my select tag..
So, I did that :

// that list contains ids I want to add in 'in' clause.
List params = new ArrayList() ;

// I put it in a Map.       
Map par = new HashMap() ;
par.put("ids", params);
        try
        {
            cards = sqlMap.queryForList("DONNEE.selectFromDonneeUUID", par);    
                    
        }


My xmlFile :

   <select id="selectFromDonneeUUID"
resultMap="abatorgenerated_DonneeResult" parameterClass="java.util.Map">

    select DONNEE_UUID,
      DESCRIPTION,
      LIBELLE,
      TYPAGE,
      EVALUATEUR,
      TSTMPINSR,
      TSTMPUPDT
    from DONNEE
    where #DONNE_UUID# in 
    <iterate
      open=" ("
     close=")" conjunction="," property="ids">
      #[]#
    </iterate>
  </select>

But it doesn't work.. 

-- 
View this message in context: 
http://www.nabble.com/help-problem-with-select-request-using-%27in%27-where-clause-tf2009665.html#a5534831
Sent from the iBATIS - User - Java forum at Nabble.com.