Well, as long as you are setting %attr before the connect, or
$dbh->{RaiseError} = 1 after the connect, I don't see why this
isn't working for you.
If I set RaiseError, and issue a select on a nonexistant table, my program
stops, unless I trap the error in an eval block.
Sorry. Maybe someone else will be more help.
----- Original Message -----
From: "Vladimir Korobko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 28, 2001 4:51 AM
Subject: Re: $DBI::errstr
> my statement connect is :
> $dbh = DBI->connect($dsn, $user, $password) ; or
> $dbh = DBI->connect($dsn, $user, $password,\%attr) ;
>
> I'm not wrapping database methods in an eval?
> and version of DBI for mysql 1.14 driver was cathed from internet one
> month ago !
>
> is it really need to use eval ?
>
>
> Jeff Waugh wrote:
>
> > What does your connect statement look like?
> > Are you wrapping your database methods in an eval?
> > Are you using outdated versions of DBI or DBD?
> >
> > Maybe a bit more code would help.
> >
> > ----- Original Message -----
> > From: "Vladimir Korobko" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, April 28, 2001 4:05 AM
> > Subject: $DBI::errstr
> >
> > > Hello all !
> > >
> > >
> > > I try to set automatic error checking for whole script !
> > > Error Checking should be done during every operation with DB like
> > > connect , execute,
> > > disconnect , prepare . And in case of error programm should be
> > > terminated !
> > >
> > > My way is :
> > >
> > > %attr = (
> > > PrintError=>1,
> > > RaiseError=>1
> > > );
> > > or
> > > $h->{PrintError} = 1;
> > > $h->{RaiseError} = 1;
> > >
> > > but during execution wrong sql query I only get this warning
> > > DBD::mysql::st execute failed: Table 'sms.pentiu' doesn't exist at
> > > ./check_available_driver.pl line 23.
> > > DBD::mysql::st fetchrow_array failed: fetch() without execute() at
> > > ./check_available_driver.pl line 24.
> > > and programm does not terminate untile Iset
> > >
> > > $sth->execute || die "$DBI::errstr\n";
> > >
> > > when it's look ok and programm is stopped with next message :
> > >
> > > DBD::mysql::st execute failed: Table 'sms.pentiu' doesn't exist at
> > > ./check_available_driver.pl line 23.
> > > Table 'sms.pentiu' doesn't exist
> > >
> > >
> > > so how I could check every operation without checking it directly?
> > >
> > >
> > >
>
> --
> Mr. Korobko Vladimir
> IN System Engineer
> Ukrainian Mobile Communications
> 21 Moskovskaya Str.,
> Kiev 01010, Ukraine
> Tel.: +380 50 110 3261
> Fax: +380 44 290 8737
>
> ************************************************
> Our Web Site www.umc.com.ua www.sim-sim.com.ua
> ************************************************
>
>
>
