i have a postgresql database created with over 20,000
rows. i'm trying to pull all the information via dbi
and it always stops at 268 rows (it works great for
the information it does send). is there a load issue
with the way dbi works? am i doing something wrong?
i've attached my perl script....
PLEASE HELP!!!!!!!!!!!!!! :)
#!/usr/bin/perl
use DBI;
require '../variables/variables.ini';
my $dbh = DBI->connect(${dbConnect}) || die "Cannot
connect to the DB: $!";
my $sth=$dbh->prepare("SELECT
O.id,O.locationid,O.shippingid,O.statusid,O.ups,O.date,O.
cost,L.store,S.method,OS.status FROM ${Orders} AS
O,${Location} AS L,${Shipping} AS S,$
{OrderStatus} AS OS WHERE L.id = O.locationid AND S.id
= O.shippingid AND OS.id = O.sta
tusid ORDER BY O.id");
$sth->execute();
while(my $order = $sth->fetchrow_arrayref) {
($OrderID,$LocationID,$ShippingID,$StatusID,$UPS,$Date,$Cost,$Store,$Method,$Status
) = @{$order};
print "${OrderID}";
print "${Store}";
print "${Method}";
print "${UPS}";
print "${Status}";
print "${Date}";
print "${Cost}";
print "*********\n";
print "*********\n";
}
$dbh->disconnect();
exit;
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
