http://qs321.pair.com?node_id=403900


in reply to Working with DBI and DBD::SQLite2

You have a quoting problem. Use placeholders!

my $sta=$dbh->prepare("INSERT INTO ISP(Store,Date) VALUES(?, ?)"); my $stb=$dbh->prepare("INSERT INTO UnityPrimary(Store,Date) VALUES(? +, ?)"); my $stc=$dbh->prepare("INSERT INTO UnitySecondary(Store,Date) VALUES +(? , ?)"); $sta->execute($store,$isp); $stb->execute($store,$pri); $stc->execute($store,$sec);

BTW, some error checking would not be out of order either.

 _  _ _  _  
(_|| | |(_|><
 _|