Re: problems with DBI::selectcol

Set the RaiseError attribute on the DBI constructor, or check $DBI::errstr to see if there's an error message.

The docs say you can also pass a prepared statement handle to selectcol_arrayref(), so try that as well.

Finally, to read the code if you don't have root access, try perldoc -m DBI.

Comment on Re: problems with DBI::selectcol_arrayref Select or Download Code

Replies are listed 'Best First'.
Re: Re: problems with DBI::selectcol_arrayref by christopherbarsuk (Acolyte) on Aug 11, 2001 at 00:21 UTC
Thanks for the response... ...$DBI::errstr is empty (as is $DBI::err, of course); tried passing a statement handle, with the same results. And, unfortunately, perldoc is broken on my system (I'll report it as a bug, but until the admin fixes it, I'm stuck) More and more I'm thinking I have a faulty DBI or DBD -- selectall_hashref is not working correctly, either.	[reply]
Re: Re: Re: problems with DBI::selectcol_arrayref by mandog (Curate) on Aug 11, 2001 at 21:26 UTC
If Perldoc is broken on your system and you don't have root access, you might install Perl / DBI / MySQL on a system where you do have access. Installing this stuff yourself is time consuming. It might be worth the time to have access to the documentation and to have a reference system that isn't broken. It might not be worth the time to install MySQ at home, but ActiveState installs quickly. PPM gets wanted modules easier than CPAN... (Though ActiveState.com doesn't seem to be reachable from my current time and location)	[reply]