Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: DBI fetchrow_array stopped working

by graff (Chancellor)
on May 05, 2014 at 02:58 UTC ( #1084991=note: print w/ replies, xml ) Need Help??

in reply to DBI fetchrow_array stopped working

When you say "it just skips the fetchrow_array part", do you mean that it seems to run "without error" (and also without printing anything in the "while" loop or updating the other database)?

If that's what you mean, then you might need to check the return value from your $sth->execute call (and the "bind_columns" call). If the "prepare" call had failed, I think you would have gotten a full-blown failure with an error message - something to the effect of "can't call method 'execute' on an undefined object." If the prepare succeeds but the execute fails for some reason, there might not be any automatic notification about that.

When you run the query manually, do you happen to notice whether the current table columns match what your script assumes them to be?

Comment on Re: DBI fetchrow_array stopped working
Download Code

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2015-07-30 07:46 GMT
Find Nodes?
    Voting Booth?

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

    Results (270 votes), past polls