Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

selectrow_array installation

by AjayUSAPerl (Initiate)
on Feb 21, 2020 at 04:30 UTC ( #11113300=perlquestion: print w/replies, xml ) Need Help??

AjayUSAPerl has asked for the wisdom of the Perl Monks concerning the following question:

I'm using PERL Web application programs that have been built for and distributed by our organization. It has been working properly on a LiquidWeb installation running cPanel 76.0.22 Linux system. I'm now ported the same code base into another installation running on GoDaddy running cPanel 78.0.38 Linux system. The application works fairly well except at a crucial place. After much tracing, I found that the 'selectrow_array() always returns an empty list. If I use individual prepare-execute-fetch calls, it works. Of course, I don't want to change the code all over the place because selectrow_array is used everywhere. The Perl modules are installed by default by GoDaddy and I can make changes if I knew what to change. Anybody seen this type of error and what am I missing in the installation? Thanks Ajay

Replies are listed 'Best First'.
Re: selectrow_array installation
by 1nickt (Abbot) on Feb 21, 2020 at 05:07 UTC

    Hi, from the doc for that wrapper method:

    If any method fails, and "RaiseError" is not set, selectrow_array will return an empty list.
    Setting RaiseError should help to find out what is the real cause of getting no rows returned.

    Hope this helps!

    The way forward always starts with a minimal test.
Re: selectrow_array installation
by roho (Chancellor) on Feb 22, 2020 at 13:55 UTC
    Welcome to the Monastery. 1nickt has provided good advice. Just a nit, though. The language is Perl, not PERL. :)

    "It's not how hard you work, it's how much you get done."

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://11113300]
Front-paged by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (7)
As of 2020-04-08 08:21 GMT
Find Nodes?
    Voting Booth?
    The most amusing oxymoron is:

    Results (43 votes). Check out past polls.