Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^4: Single column Query into Multiple Arrays

by cocl04 (Sexton)
on Nov 14, 2008 at 14:17 UTC ( #723659=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://723659]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (4)
As of 2020-12-04 15:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (60 votes). Check out past polls.

    Notices?