Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Single column Query into Multiple Arrays

by cocl04 (Sexton)
on Nov 13, 2008 at 22:44 UTC ( #723524=note: print w/replies, xml ) Need Help??


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

Thank you! I assume that in order to increment the array index...I have to use a while or a for loop??
  • Comment on Re^2: Single column Query into Multiple Arrays

Replies are listed 'Best First'.
Re^3: Single column Query into Multiple Arrays
by snopal (Pilgrim) on Nov 14, 2008 at 13:55 UTC

    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.
      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://723524]
help
Chatterbox?
and the web crawler heard nothing...

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





    Results (60 votes). Check out past polls.

    Notices?