> -----Original Message-----
> From: Bakken, Luke [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 05, 2005 5:24 PM
> To: Ryan Frantz
> Cc: beginners@perl.org
> Subject: RE: Missing objects in Database
>
> Ryan Frantz wrote:
>
> > But that does not work. Then I saw that for non-SELECT statements
> > (which I assume an EXEC is not; I'm new to DBs), that it will return
> > "OEO" if nothing was affected. I think, though, that this refers
more
> > to INSERT and its ilk.
> >
> > Should I set RaiseError to 1?
> >
> > $dbh->{RaiseError} = 1;
> >
> > Will that help me skip over errors? Or just give me better output
> > when I do encounter one? I'm going to monkey around with it.
>
> Ah I thought that DBI threw errors by default to be trapped with the
> eval(). Turn RaiseError on.
I set {RaiseError} = 1 and the script bombed part way through during an
execute with the following error:
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Line 1: Incorrect syntax near '<'. (SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at sp.pl line
29.
Line 29 is this:
$sth_space->execute;
The error noted "Incorrect syntax near '<'." but I've checked the values
in my @tables list and none of them have that character in them. I
assume, then, that this is a problem with the ODBC driver. Any
suggestions as to how I can troubleshoot this one?
ry
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
