Webmaster Forum / Perl / DBI Library / November 2006

This is from code that is several years old which runs fine on other
servers with older versions of Class::DBI.
I'm getting an inexplicable error:
Can't locate object method "last_insert_id" via package

I'm having some issues with using Class::DBI with utf8 data in an  
oracle database.
I have to make all the columns 'Essential' or everything just hangs  
when I try to retrieve non-primary key columns.

Hi: my dba has asked to execute a alter statement before the select
statement. So I need to run the following
alter session set db_file_multiblock_read_count = 128;
SELECT ED.utime, ED.info, ED.agent_id FROM EVENT_DATA ED WHERE ED.utime

I am simply testing a DBI->connect, $dbh->prepare and $sth->execute for
the following bundled SQL statement.  I am not receiving any errors at
all.  I should have received the following error:
Error: ERROR: Relation 'tmp_ppv_store_panel_seq' already exists

For a given column Is it possible to search for more than one value?
for instance how would I search for an employee with the first name of
either "William" or "Bill"?
# Search for "William".

I'm using SQLOLEDB to connect to a MSSQL database where I've inserted
some data using the "BULK INSERT" with the option "SET DATEFORMAT DMY".
The SO language installed on the computer where the Sql Server and my
programs runs is English with "Italian" as regional option.

I'm finding that when I do :
while (my $object = $iterator->next) {
..
}

Right, I don't know if the subject of this message really makes any
sense, but at least it's an attempt.
So anyway, my problem.
I'm constructing a fairly complex search that could cover relationships

Hi Tim et al.
Please see the suggestion below for an amendment to the DBI readme.
Sounds like a good idea to me.
Regards,

I'm sure I'm missing something *very* obvious but this one has me
scratching my head.  Using DBI 1.52, DBD::mysql 3.0007, Perl 5.8.8,
MySQL 5.0.18.
The following code executes fine:

Hello. I have an issue I've noticed when trying to migrate a backup
script I wrote to work with ASE 15.0.1. In my script I use the dbpoll()
function within Sybase::DBlib to monitor the results from a dbcc command
and report if it takes longer than I expect. What's happening is that

"the same compiler that was used..."
I'm getting the error that Tim Bunce described in the
README for DBI:
 If you get compiler errors refering to Perl's own

Went looking for the symbol, and didn't find it
in PurePerl, but it is in dbi_sql.h, so this needs
to be added somewhere between lines 51 and 107 of PurePerl.pm
(from DBI-1.53 RC1 pkg):

i am new to class::dbi and using class::dbi::loader
for simple db stuff. i read the cdbi page about
transaction and it mention that with:
 Music::DBI->do_transaction( sub {

This is slightly off topic, but I figure people on this list may be able
to help me out here.
I've got a lot of perl software that uses C::DBI, of which the DBI
subclass stuff is reverse-engineered from a MySQL database (using the