on Tue, 21 May 2002 12:34:53 GMT, [EMAIL PROTECTED] wrote:
> my $sth = $dbh->prepare("select rollup_code, rollup_value,
> french_flag
> from FMC_REPORT_CREATE_PARAMS
> where aggr_rpt_id = 2
> order by report_seq_num");
> $sth->execute;
>
> while ( @row = $sth->fetchrow_array ) {
> print "@row\n";
> }
All of this code looks OK to me. The error you get has to do with the
fact that '$dbh' is not defined. Did you check the return value of your
'connect'-call, as in
my $dbh = DBI->connect(...) or die "Cannot connect: $DBI::errstr";
--
felix
