in reply to Clean a database record off an apostrophe '
map {$dbh->quote($_) } ($custno, $companyName, $address, $city, $state +, $zip); [download]
or, for double quotes around most values, try $dbh->quote_identifier($_) in the map instead.
hth, --au