On Sat, Feb 09, 2002 at 09:50:14AM +0100, Bodo Eing wrote:
> Ashwini,
>
> > hi,
> >
> > I have a perl script here which fetches data from the mysql database
> > using the fetchrow_array method. I have this script running on 2
> > different machines. unfortunately this fetchrow_array call works on
> > one machine and not on another. I used the rows calls to check how
> > many rows are returned by the previous query. It shows me the correct
> > value but then I try to fetch each row of the result, it doesn't
> > retrieve anything.
> >
> > This is the code I am using.
> >
> > &MakeDatabaseConnection;
> > &MakeDatabaseQuery($query);
> > while(@row = $sth->fetchrow_array)
> > {
> > print $row[0];
> > }
> > &BreakDatabaseConnection;
> >
> > where the fetchrow_array doesn't pop any data.
> > Any idea why this could be happening?
>
> No. Without knowing the code in your subroutines there won't be much
> help for you. Are you use ing strict and have set RaiseError => 1 ?
And (let's all sing it together)...
WHEN IN DOUBT, TURN ON THE TRACE!
Tim.
