Do you have rights to update the table on the production database? > -----Original Message----- > From: Mark Martin [mailto:[EMAIL PROTECTED] > Sent: 02 April 2004 14:53 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: My DBI script wont UPDATE a Table! > > > Hi, > I designed my application on a test database and it worked > fine without commiting the database handle. But now when I've > moved it to the production database my updates wont commit - > even when I do issue a commit on the DBH?!?! > > while(certain condition) { > $sql = qq{UPDATE table > SET field=value} ; > $sth = $dbh->prepare($sql) ; > $sth->execute; > > $dbh->commit(); > > } > $sth->finish; > $dbh->disconnect; > > I've tried the commit outside the while statement with no > luck. Any ideas? > Mark >
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
