Re: Sqlite DBI duplicate record


Clear questions and runnable code get the best and fastest answer
	PerlMonks

Re: Sqlite DBI duplicate record

by roboticus (Chancellor)

on Mar 07, 2013 at 19:34 UTC ( [id://1022298]=note: print w/replies, xml )

Need Help??

in reply to Sqlite DBI duplicate record

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.