Readers:
I'm running a query on a list (input file) and capturing the first column
of the results to an array.
When I print the array, the first element is null why is this ??
There are 5 items in my list, 6 rows of output.
My goal is to do more processing on @skulisting (which requires not having a
null entry), not just to print the results.
---------------------------------------------
## Begin Code
use strict ;
use DBI ;
my $item_number ;
$dbh = DBI -> connect......
while (<INPUT>) {
chomp $_ ;
$item_number =$_ ;
$sql_stmt =<<"EOF+"
select sku_mark, description from inventory
where item_number = $item_number
EOF+
$sth = $dbh -> prepare ;
$sth ->execute ;
while (@row = $sth->fetchrow_array ) { ## Capture the sku mark
push (@skulisting, $row[0]
}
foreach $entry (@skulisting) { ## Print the sku mark
print $entry . "^^^^^^^^\n" ;
}
=================================
Results:
^^^^^^^^^^^^ ## Why is this line of output here??
5134313234
3923392432
TIA
Frank
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
