sybperl-l Archive

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: No error raised for bad SQL in prepare() or fetchall_arrayref()
Date: May 6 2004 4:29PM

On Thu, 2004-05-06 at 18:24, Avis, Ed wrote:
> I expected this program to raise an exception for the bad query, but
> it runs happily.
> 
>     use warnings;
>     use strict;
>     use DBI;
>     my $dbh
>        = DBI->connect("dbi:Sybase:server=MY_SERVER;database=mydb",
>                       'login', 'password',
>                        { RaiseError => 1 });
>     my $sth = $dbh->prepare('malformed junk');
>     $sth->fetchall_arrayref();

Err - no $sth->execute().

Typo?

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html