On Friday, May 24, 2002, at 02:56 , Johnson, Shaunn wrote:
> open COUNTFILE, ">$mbr_count";
> print COUNTFILE "Count of member in test table\n\n";
> print COUNTFILE "Please review\n\n";
> ***PROBLEM AREA***
> if ( ($memcount < 1500000 )=$sth->fetchrow) {
> print COUNTFILE "$memcount is all good ... next phase please\n";
> } elsif {
> print COUNTFILE "$memcount is not good ... get to work\n";
> } else {
> print "some other error: $!";
> }
>
> close COUNTFILE;
since you R rowFetching - don't you want to have that as
my $memcount = $sth->fetchrow ;
if ( $memcount < $topVal && $memcount >= $nextVal) {
}elseif (.....) {
}.....
I will defer to the DBI guru's on how one goes from sending
rover to fetch a bone, but once you have the bone, make
sure that it is between ranges.... so you might want to think in
terms of say
my @range_war = qw/0 100 200 300 .../;
hence you can do your RangeChecking in the form
if ( $memcount >= $range_war[0] && $memcount < $range_war[1] ) {
}elsif ( $memcount >= $range_war[1] && $memcount < $range_war[2] ) {
} .....
makes the cuting and pasting easier....
ride 'em kowPerKin....
ciao
drieux
---
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
