Top "Dbi" questions

How can I check if a database query will return results?

Our website uses Perl to provide a simple mechanism for our HR people to post vacancies to our website. It …

perl dbi rows

Perl warning: Use of uninitialized value in join or string

I'm getting: "Use of uninitialized value in join or string at ./test_script.pl line 69, <fh> line 91." The …

perl warnings dbi

Why does Apache complain that my mod_perl program "disconnect invalidates 1 active statement handle"?

disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) The following code which …

mysql perl apache dbi

Database fetchrow_array failed long truncated DBI attribute

i am pulling urls from my database with a perl script where i employ fetchrow_array to pull URL from …

perl dbi

Dump prepared sql query from DBI statement in PERL

im using DBI in Perl to connect to my PostgreSQL Database. Everything is working fine but in my debugging (printing …

perl debugging dbi dump

Installing CGI, DBI and DBD::Oracle with Solaris 11 64-bit

I tried to install CGI, DBI and DBD::Oracle and drivers in a 64-bit Solaris environment, but to little avail. …

perl oracle solaris dbi dbd

Is there an equivalent of PHP's mysql_real_escape_string() for Perl's DBI?

Could some tell me if there is a function which works the same as PHP's mysql_real_escape_string() for …

perl dbi mysql-real-escape-string

How do I get the number of affected rows when I use DBI's prepare/execute for non-select statement?

According to the DBI documentation, it seems I can only get the number of affected rows by the do method. $…

perl dbi

Why does SQLite give a "database is locked" for a second query in a transaction when using Perl's DBD::SQLite?

Is there a known problem with SQLite giving a "database is locked" error for a second query in a single …

perl sqlite prepared-statement dbi dbd

perl dbi reconnect on disconnect

I have searched google but could not find an answer to what I think is an easy question. I have …

mysql perl dbi