in reply to Re: Re: Re: Re: Re: Updating Specific Fields in MS Access
in thread Updating Specific Fields in MS Access
but still get:#! C:\perl\bin\perl.exe -w use DBI; #use strict; my $DSN='Database'; my $driver; my $servlist; #connect to database my $dbh=DBI->connect("dbi:ODBC:$DSN", "admin", "") || die; my $sqlstatement=("UPDATE Servers SET Servers.nic1_driver_version=? WH +ERE server=?"); my $sth=$dbh->prepare($sqlstatement); #Open file for reading open(INPUT,"file.txt") || die; while (<INPUT>) { chomp; my ($servlist, $driver)=split(/,/); $sth->execute ($driver,$servlist) || die; } close (INPUT); $dbh->disconnect;
|
|---|