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
[EMAIL PROTECTED]
Mike Zatko
<[EMAIL PROTECTED]
om> To
[EMAIL PROTECTED]
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
