Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: DBI ignoring devide by zero

by runrig (Abbot)
on Sep 28, 2012 at 18:48 UTC ( #996274=note: print w/replies, xml ) Need Help??


in reply to DBI ignoring devide by zero

Did you feed that sql script to a command line query tool? What does that query tool do? I fed it to Sybase's isql, and did not get an error there either. It's not DBI, it's the database ignoring the error. In general, do not execute more than one SQL statement at a time. If you do them one at a time, you do get an error.

Replies are listed 'Best First'.
Re^2: DBI ignoring devide by zero
by emptyfull (Initiate) on Oct 02, 2012 at 13:42 UTC
    its not DBMS for sure
    i tried same sql code with C++ and ODBC and i get error message
    i tried it with command line osql
    and i get Msg 8134, Level 16, State 1, Server FIENYSQL, Line 6 Divide by zero error encountered.

      Do you check for errors?

      When creating the database connection, pass the { RaiseError => 1 } attribute or do manual checks for errors whenever you run an SQL statement.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://996274]
help
Chatterbox?
[Marshall]: I also looked into PerlApp from Active State, but they don't sell their Dev Kit independent of a very expensive ($1,200) per year license anymore.
[Corion]: I would assume that the PE format hasn't changed that much since the days of yore, but it seems that I would be wrong in that assumption
[Marshall]: When I bought my copy 15+ years ago, it was just a couple hundred bucks.
[Marshall]: I looked at MS specs for PE format and I didn't see any changes in last decade, but evidenly that would be wrong.

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (10)
As of 2016-12-08 18:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (144 votes). Check out past polls.