Webmaster Forum / Perl / DBI Library / January 2006

I want to render all the triggers in a class ineffective for the
duration of a sub routine.  Anyone have a good idiom for this? In the
data migration script, the triggers are getting in the way (creating
things that already exist and need to be migrated and such).

After over 14 months a new release of DBD::Oracle is almost ready.
This will be a significant release for several reasons, but before the
actual release I want to get as much test coverage as possible.
The good folk on dbi-dev have already done much testing (hence this

This one doesn't involve actually changing any files, but adjusting
some environment vars and symlinks. This makes upgrading relatively
painless:
( unzip and copy resulting dir to /opt/instantclient)

I'm trying to work out how to search a database by emailaddress.
I'd like to see if an emailaddress exists in a database already.
The code looks like this:
/~~~~~~~~~~~~~~~~~~~~~~~~~~~

FYI I'm planning on making the next release (1.51) be the last that
officially supports perl 5.6.
This is partly to make it easier to implement changes in future
releases that improve performance with threaded perls. This will benefit

I created a table in mysql in which i  set a field "id" in that table to
auto_increment and this field is the primary key to this tabel. so each
time  a new record is added the id increment by 1. When i delete a last
record and insert the next record it increment the value from the ...

A few things come to mind:
Makefile.PL indicates: Warning: LD_LIBRARY_PATH doesn't include
/users/openlink, which may be a red-herring for the mis-recognized
driver.

I'm using swap_inner_handle in a HandleError sub to re-connect
the existing database handle. The trick is to re-connect if
the error warrants it, return false to the caller, which then
allows the caller to re-try the failed operation and keep

I have a cgi script adduser.cgi which collects the data from the user
through adduser.html. when i execute this script i encountered the error as
shown below.
Name "dbi::errstr" used only once: possible typo at adduser.cgi line 18.

All,
I've been using Class::DBI for a bit now and came up with what I  
think are a couple of nifty extensions I thought I might share, if  
only to ask if I've simply reinvented someone else's wheel.  The  

I had been running into this error (under CDBI 3.0.14):
Deep recursion on subroutine "Class::DBI::_flesh" at
/usr/lib/perl5/site_perl/5.8.5/Class/DBI.pm line 837.
Deep recursion on anonymous subroutine at

Hello List,
 I have an XP machine with several open client 12.5 and 15.0 installed.
My perl scripts are broken because  DBD::Sybase can't be loaded
I guess this is so   since I have the 15.0 client installed.

I did according to the instruciton: http://www.esoftmatic.com/DBI/.
But I found the problem as in title :
install_driver(Oracle) failed: DBD::Oracle object version 1.15 does not
match bootstrap parameter 1.06 at

hello evrybody,
I have problems in installing DBI module, it require another library "cl"
that i dont find
please help me

From DBI's pod:
   This only works for methods which return a single value
   and is hard to make reliable (avoiding infinite loops,
   for example) and so isn't recommended for general use!