This is bug in your code:
On Mon, 2004-04-26 at 11:11, Jesse, Rich wrote:
> while ( my ($projectno,$description,$dateclosed) = $sth->fetchrow_array )
> {
last if not defined $projectno; #fetchrow_array is done
> print "$projectno";
> print "$description";
> print "$dateclosed";
> print "\n";
> }
This only works if projectno is a NOT NULL column. (It would be kind of
stupid to allow nulls in something like this however). Otherwise, you
are better of NOT using fetchrow_array. Conside fetchrow_arrayref(), or
binding your return values, and calling fetch(). (I like the latter
because its _simple_ and explicit, and only a few extra lines of code.
Lincoln
