Mega Code Archive

 

Categories / Perl / Database

 

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();