http://www.perlmonks.org?node_id=723659


in reply to Re^3: Single column Query into Multiple Arrays
in thread Single column Query into Multiple Arrays

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