Webmaster Forum / Perl / DBI Library / October 2005

I've written a CGI script (not mod_perl) and am looking to use
connect_cached to improve connection times. However, I have a couple of
questions.
Does it work in a non-persistent environment? I assume so, since there's no

I have a Win32::OLE code, like bellow, running to get and parse a DBCC SHOWCONTIG, and a catch the result of
DBCC by SQL messages errors.
<code>
use Win32::OLE qw(in);

Hi.   I have a base class search method that  i want to be called
first by my sub classes and then have the IsA search method be next in
inheritance tree.   Currently when the Isa relationship sets itself
up, it overwrites the search method of the base cllass.   In other

Hi team,
Class::DBI can't support the view for MySQL 5, Has any solution for the case?
Thanks.
[Sun Oct 30 16:41:45 2005] [catalyst] [debug] Couldn't load tables "blog_view has no primary key at /usr/lib/perl5/site_perl/5.8.0/Class/DBI/Loader/Generic.pm line 196

I have a strange problem with mysql 4.1 (innodb engine) and
DBD::mysql 2.9006:
A dbh->begin_work immediately after a dbh->commit fails with
the error "Already in a transaction".

Edward J. Sabol wrote:

I keep running into this inconsistency in using triggers and was wondering
if there is a standard way to get around it.
The statemtnt
my $foo=Foo->create({first=>"hello", second=>"world"});

I have some classes which references objects which use Class::DBI,
more exactly, a session object which store a user object.
In a function which checks to see if the user is still a valid user in
the system (sessions are supposed to last for a while), I want to

is there a method that deletes entries from a lookup table in a many-to-many relationship? Some autogenerated method similar to 'add_to_<my_method> [which could be called 'remove_from_<my_method>]?
I've had a (long) look at the docs and the Wiki entries but could not find anything ...

I have a query, which needs a date substituting twice. Declaring an intermediate variable seemed the natural way to do this viz:
my $nots = $dbh->selectall_arrayref(<<SQL, {}, $end);
declare \@eom datetime
select \@eom = ?

I have multiple mod_perl applications running within one Apache instance.  For most of these applications, I want to use Apache::DBI, but I want to disable it for just one.  According to various Web pages, this is not possible, because Apache::DBI attaches itself to all ...

Heya DBI-Users
Can anyone help a DBI::Statement newbie with the following problems:
1. When parsing a SQL string, is there a preferred way for initially testing
whether the statement did or did not parse successfully?

Hello,
I have an Oracle 9iR2 , ActivePerl 5.8.7.
I downloaded DBI First, and DBD::Oracle 1.16 on the site Active PPM.
I have an error :

    After applying a Sybase maintenance pack, starting getting the following messages from perl applications using the modules:
DBI connect('SYB_SS','DBS',...) failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (4)
Server SYB_SS, database
Message String: ...

It looks like there is a new fork of Class::DBI up on CPAN.  I haven't
seen any talk of it here on the list so it caught me by surprise...
http://search.cpan.org/~sri/Class-DBI-Frozen-301-3.0.1/lib/Class/DBI/Frozen/301.pm
Cheers,