Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^3: Catching DBI (or other) errors

by Crackers2 (Parson)
on Mar 08, 2006 at 18:20 UTC ( #535222=note: print w/replies, xml ) Need Help??


in reply to Re^2: Catching DBI (or other) errors
in thread Catching DBI (or other) errors

That would execute all queries even if one of them failed though. And if after your code finishes, $sql_stage is 1, you still don't know whether it was $query or $query2 that failed. Now add 3 or 4 more queries to that list and the $sql_stage variable becomes practically useless for anything except comparing to the total number of queries.

Replies are listed 'Best First'.
Re^4: Catching DBI (or other) errors
by clinton (Priest) on Mar 09, 2006 at 10:31 UTC
    But wrapped in an eval and combined with RaiseError, it would stop counting at the point where your query goes wrong.

    It is a bit annoying in that you have to count your queries to know which went wrong, but there may be one or two specific action points: if queries 1-4 succeeded, but 5-8 failed do X, otherwise do Y.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2023-02-05 11:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (31 votes). Check out past polls.

    Notices?