Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: more and more dbi issues

by sutch (Curate)
on Apr 04, 2001 at 23:09 UTC ( #69805=note: print w/ replies, xml ) Need Help??


in reply to more and more dbi issues

One idea: could autocommit possibly be off? If so, you will need $dbh->commit to commit the changes to the database.

Update: fixed a typo.


Comment on Re: more and more dbi issues
Download Code
allowed
by Anonymous Monk on Apr 05, 2001 at 02:03 UTC
    am i allowed to have these statements in a loop or is this against dbase rules. does it compromise dbi standards to have 3 updates running 13 times in a loop??? is there protection against this. if this message doesn't make sense i've been coding 4 10hrs flat and am slowly shutting down. i hope u get the gist.

      According to House Bill 17289, in preparation, programming loops will no longer be able to nest beyond two levels deep. It looks like this sucker's going to become law, so you'd better hope that your code gets grandfathered in.

      In other news ... DBI won't prevent you from shooting yourself in the foot -- if you issue updates upon updates of the same row, it won't complain. Your DBMS might, on the other hand. It's up to you to ensure that your code's correct, here as nearly everywhere else.

      Philosophy can be made out of anything. Or less -- Jerry A. Fodor

        i took it out of the loop i removed the and statements and it works is there anything wrong with the and statements it works in sql manually i cant get it to work if there's even 1 and statement. i know someone who got it to work on the same system here with one and statement any ideas??

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (9)
As of 2014-12-21 02:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (101 votes), past polls