Thank you! The array is working. I put the array in a while loop wit
+h $i = 0 and I increment it. I tried to pass the array to my query.
+ The query will only read the first array index. Each time it goes t
+hrough the loop, it will print the value for the next index. But the
+ Oracle query will only return data for the first index. Instead of
+passing the array directly, I assigned it to a global value. It also
+ prints the data, but only passes the first value. How can I get the
+ query to reconize the value for each increment.
i.e.
use DBI;
use strict;
use vars qw($value);..........
while ($i<=2)
{
print "$array[$i]\n";
$value = "$array[$i]";
print "$value\n".......
############################
#
# Set up Query for Store
#
############################
my $stmt = "select
week_end_date, SVP, RD,
DM, store, wtd_smrr_gain,QTD_SMRR_GAIN,
wtd_bor_gain,QTD_BOR_GAIN,
wtd_cust_gain,QTD_CUST_GAIN,
WTD_CARD_CLOSED,QTD_AVG_CARD_CL
from
bonus_4Q_store
where
SVP <> 'RD' and RD = '$value'
order by
svp,dm,store"; ......
$i++......
};
|