in reply to Re: If no results come back ...
in thread If no results come back ...

It has to be in a while or for statement cause it gets more than 1 row

Replies are listed 'Best First'.
Re: Re: Re: If no results come back ...
by Anonymous Monk on Jul 21, 2002 at 03:52 UTC
    so what is the problem? ( why don't you just put it in a while or for loop or do you need further instruction?)
[reply]
      further
[reply]
        Something like: 
        my @results;
while (my @row = $sth->fetchrow_array) {
   push @results,\@row;
}
if (@results) {
   ...we got something...
} else {
   ...we got nothing...
}

        [download]
        might help, though I woundn't use it in the case where a large result set is expected/possible. If large results sets are expected/possible then a flag might help: 
        my $results = 0;
while (my @row = $sth->fetchrow_array) {
   $results++;
   ...do some stuff
}
if ($results) {
   ...we got something...
} else {
   ...we got nothing...
}

        [download]

        rdfield

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom