Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by moritz (Cardinal)
on Jul 05, 2013 at 19:48 UTC ( #1042780=note: print w/ replies, xml ) Need Help??


in reply to 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!).


Comment on Re: Mystified by why my UPDATE statement is not reflected in my database display
Select or Download Code
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1042780]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (9)
As of 2014-09-03 02:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls