in reply to $sth->execute problem

$SQL2 doesn't have a placeholder in it (ie, no '?'), but in your foreach loop, it is getting executed with $street.

Scott
Project coordinator of the Generic Model Organism Database Project

In Section Seekers of Perl Wisdom