I'm am trying to get simple html page to work with a script using dbi and cgi. It works fine in mysql but when I change the dbname from DBI:mysql:test to DBI:ODBC:HERM which is a totally different database the html and script stop working. Has anyone seen this problem before, and if so could someone please help? Here is the perl code that I'm using.
Thanks in advance..
# Get the input for POST method
#Split the name-value pairs
# Substitute special character to its original character
$value=~ tr/+/ /;
use DBI ;
use CGI ;
$statement = "UPDATE staf SET name='superman' where name='$value'";
$dbh = DBI->connect(dbname, $user, $password) || die "$DBI::errstr";
$sth = $dbh->prepare($statement) ;
$sth-> execute() ;