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


in reply to DBI, SQL and Dates

If you want the single quotes, then surround the string with double quotes:
$dbhstmt->execute( "'$SuStCo_strID'", "'$date'" );
I suggest this, as it's a good idea to have quotes around anything going into SQL, to stop nasty input tricks.