welle:

You should be able to do that:

$STI = $DB->prepare('insert into foo (a, b) values (a, b)');
$STS = $DB->prepare('select a, b from bar');
$STS->execute();
while (my $ar = $STS->fetchrow_arrayref()) {
    $ar->[1] = defined($ar->[1]) ? $ar->[1] : '=null=';
    $STI->execute(@$ar);
}
[download]

...roboticus

When your only tool is a hammer, all problems look like your thumb.