> >print STDERR "Got here 1.3\n"; > > > >my @a = $sth_data->fetchrow_array() or die "fetchrow_array: > >$DBI::errstr\n"; > > > >print STDERR "Got here 1.4\n"; > > > > What's in @?
The program ends on that line, so unfortunetly I can't examine @a. > And if the answer to that doesn't help, what DBD are you > using and does > the query work when done through a command line interface > like pgsql or > its equivalent for your RDBMS? Sorry about the lack of version info, we're using DBI-1.40, DBD-Pg-1.31, and PostgreSQL-7.3.5. The query works fine in psql. The weird thing is that the program just ends...no error messages, nothing...it's just like there was an exit; buried in fetchrow_array(). Another thing is That this code worked fine with DBI-1.20 and DBD-Pg-1.01. Thanks, dianne
