Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
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 browsing the Monastery: (11)
As of 2015-07-05 20:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (68 votes), past polls