Perhaps placeholders would make your life easier:

my $sth = $dbh->prepare("INSERT INTO prospect (name, address, address2
+, state, 
                         city, [snip]) VALUES (?,?,?,?,?,[snip])";

$sth->execute($prospect->name,$prospect->address,$prospect->address2,[
+snip]) 
    or die print DBI->errstr;
[download]

-Blake