Re: Mystified by why my UPDATE statement is not reflected in my database display

For debugging purposes it's usually a good idea to pass the RaiseError => 1 option to the connect call, just in case you forget to print the DBI->errstr somewhere.

Also DBI->trace(1) might provide some insight.

Finally it is recommended that you explicitly pass AutoCommit => 1 or AutoCommit => 0 to the connect call (and in the latter case don't forget to commit your changes!).

Perl 6 - the future is here, just unevenly distributed

Comment on Re: Mystified by why my UPDATE statement is not reflected in my database display Select or Download Code

Replies are listed 'Best First'.
Re^2: Mystified by why my UPDATE statement is not reflected in my database display by OfficeLinebacker (Chaplain) on Jul 05, 2013 at 20:31 UTC
Ah, thanks. Setting RaiseError and AutoCommit to 1 didn't change anything (either output or behavior). I'll have to pipe the output of the trace to a file and examine the file, since this is a CGI script. I guess the Carping of stuff to the browser doesn't work for trace from DBI, because I tried and I get no output to the browser.	[reply]