Update statement and DBI ODBC connection : update « Database « Perl






Update statement and DBI ODBC connection

   

#!c:/perl/bin

use DBI;

$dbhandle = DBI->connect("dbi:ODBC:address");

$sqlstatement="UPDATE emp SET firstname='W', lastname='W' WHERE address='A'";

print "Content-type: text/html \n\n";

$statementhandle = $dbhandle->prepare($sqlstatement);

$statementhandle->execute || die "<br><br>Could not execute SQL statement ... <br>";
print "<br><br>Executed ...<br>";

$dbhandle->disconnect();
$statementhandle->finish();

   
    
    
  








Related examples in the same category

1.Update a record in the database
2.Update record with OLE connection