Re^2: fetchall_arrayref({}) call freezing

Hi,

in this case I have two guesses:

Columns DP1 and DP2 don't exist, so that select * is fetching something different.
You have a weird case sensitivity problem, where one part of the stack seems to be not case sensitive and the other part is case sensitive.

But, by the way: Whe you work with DBI and want to do the error handling on your own, than you have to check every DBI method, e.g. my $sth = $dbh->prepare($sql); should also be checked. On the other handside you can enable exceptions with $dbh->{RaiseError} = 1; which is IMHO much easier and an exception is thrown as soon as something went wrong. Especially in debugging cases I would prefer to set RaiseError.

McA

Comment on Re^2: fetchall_arrayref({}) call freezing Select or Download Code

Replies are listed 'Best First'.
Re^3: fetchall_arrayref({}) call freezing by banesong (Acolyte) on Mar 24, 2014 at 18:55 UTC
I know that DP1 and DP2 exist, and I have the column name correctly capitolized. I will enable raise error and see what happens, thanks.	[reply]