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++......
};
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.