ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Zatko <mza...@boscovs.com>
Subject Using the IN operator
Date Thu, 20 Jan 2005 18:23:14 GMT
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