Top "Dbi" questions

How do I know how many rows a Perl DBI query returns?

I'm trying to basically do a search through the database with Perl to tell if there is an item with …

mysql perl dbi

How do I connect with Perl to SQL Server?

I have a user id, password, database name and datasource details. I want to connect with Perl to a MSSQL …

perl dbi

Fetch all records using Perl DBI

I have a Perl script that uses a DBI connection. I open and read the SQL script file using a …

perl dbi

How can I fetch the last row I inserted using DBI?

How can I fetch the last row that was inserted using DBI (DBD::mysql)? Code sample: my $sth = $dbh->…

perl dbi

How can I fetch a single count value from a database with DBI?

The following code seems to be just too much, for getting a single count value. Is there a better, recommended …

database perl dbi

How can I get column names and row data in order with DBI in Perl?

I'm using DBI to query a SQLite3 database. What I have works, but it doesn't return the columns in order. …

perl sqlite dbi

How can I handle unicode with Perl's DBI?

My delicious-to-wp perl script works but gives for all "weird" characters even weirder output. So I tried $description = decode_utf8( $…

perl unicode dbi

Perl DBI fetchall_hashref

Consider the following table: mysql> select * from vCountryStatus; +-------------+------------+------+---------+--------+-----------------+ | CountryName | CountryISO | Code | Status | Symbol | …

mysql perl dbi hash

Can't locate DBD/Oracle.pm in @INC

I'm trying to connect to Oracle via DBI, but can't make it work. My setup: # cat /proc/version Linux version 2.6.18…

linux oracle perl dbi dbd

How can I print the SQL query executed after Perl's DBI fills in the placeholders?

I'm using Perl's DBI module. I prepare a statement using placeholders, then execute the query. Is it possible to print …

mysql sql perl prepared-statement dbi