Iteration is a process used in objects to step though the member list of the component you require. It does not usually involve visible indexes since the purpose of an iterator is to maintain a pointer to the last used item, then when called it moves on to the next object.

Using any appropriate looping code process is the standard method for reviewing those iterated objects, as long as that process detects the end of list indicator (usually undef) to break out of the loop.

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.
[download]

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++......
};
[download]