ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cory.Best...@courts.mo.gov
Subject Re: Using the IN operator
Date Thu, 20 Jan 2005 18:36:09 GMT




I have one in statement to return data for specified circuits and if none
are specified it returns data from any circuit.

    <isNotEmpty prepend="AND" property="circuits">
      L.CIRCUIT_NUMBER
      <iterate property="circuits" open="IN (" close=")" conjunction=",">
        #circuits[]#
      </iterate>
    </isNotEmpty>


Cory Bestgen
Computer Information Technologist II
Information Technology Division
Office of State Courts Administrator
(573) 522 - 5455
cory.bestgen@courts.mo.gov


                                                                           
             Mike Zatko                                                    
             <mzatko@boscovs.c                                             
             om>                                                        To 
                                       ibatis-user-java@incubator.apache.o 
             01/20/2005 12:23          rg                                  
             PM                                                         cc 
                                                                           
                                                                   Subject 
             Please respond to         Using the IN operator               
             ibatis-user-java@                                             
             incubator.apache.                                             
                    org                                                    
                                                                           
                                                                           
                                                                           




Hello. I have the following query which uses an IN operator.

SELECT
SNAPSHOT_TIMESTAMP as snapShotTimestamp, INSTANCE_NAME as serverName,
sum(IFL_USAGE) as usage
FROM
vmiflgrp.VM_IFL_STATS where
SNAPSHOT_TIMESTAMP between '2005-01-14 00:00:00.000000' AND '2005-01-15
00:00:00.000000'
AND  INSTANCE_NAME in ('LXDB01','LXWADM1','LXWAPP1','LXWEB1')

GROUP BY SNAPSHOT_TIMESTAMP,INSTANCE_NAME


How would I substitute the values
"'LXDB01','LXWADM1','LXWAPP1','LXWEB1'" in sqlmaps?

Thanks!

--
Michael H. Zatko
Java Enterprise Developer
Boscov's Information Services
Work: 610-929-7317
Home: 610-376-1624
Page: 610-736-4460




Mime
View raw message