Paste in your database connect statement. Are you setting RaiseError,
PrintError, and AutoCommit? Which database are you using? Are you
doing any error checking of DBI statements? And as was just pointed out
by someone else, does the user you are connecting with have update
permissions in your
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) {
$s
