++ to derby.

In the spirit of TIMTOWTDI, here's another way to do the same thing:

my $sql = "INSERT INTO tblErrorLog (clientID, streamID, errorDetails) 
+VALUES (?,?,?)";
         
my $sth = $dbh->prepare($sql);
$sth->execute($clientID,$streamID,$message);
[download]

When you use placeholders in this manner, all the values are automatically quoted by DBI.

- Matt Riffle