# $loc_sql =~ s/\?/'cust_main_county.'.shift(@param)/e;
# }
- warn "\nLOC_SQL:\n$loc_sql\n";
push @where, "
0 = (
SELECT COUNT(*) FROM cust_main_county
$loc_sql =~ s/\?/$ph{shift(@param)}/e;
}
- warn "\nLOC_SQL:\n$loc_sql\n";
push @where, $loc_sql;
}
). ' ) ';
- warn "\nLOC_SQL:\n$locs_sql\n";
push @where, $locs_sql;
} else { #scalar(@counties) <= 1
$loc_sql =~ s/\?/$ph{shift(@param)}/e;
}
- warn "\nLOC_SQL:\n$loc_sql\n";
push @where, $loc_sql;
}