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 ?
> Please help!!
> Thanks
> Ashwini
>
Bodo
