sybperl-l Archive

From: Lars Brueckner <brueckne at darmstadt dot gmd dot de>
Subject: DBD::Sybase 0.06: Strange errors with Datetime fields
Date: Dec 9 1997 12:27PM

Hi there,

I'm using perl5.004_01 with DBI 0.90 & DBD::Sybase 0.06 to connect
to a Sybase 11 Server on the same machine (Solaris).

I've set PrintError=>1 upon connection.

I'm generating some inserts which contain Datetime values, and I
get I lot of Messages like:

>Server message:
>Message number: 249, Severity 16, State 1, Line 1
>Message String: Syntax error during implicit conversion of VARCHAR >value '"19971213 13:12"' to a DATETIME field.

>Server message:
>Message number: 249, Severity 16, State 1, Line 1
>Message String: Syntax error during implicit conversion of VARCHAR >value 'dateadd(mi,3,"19971213 13:12")' to a DATETIME field.

However the inserts are executed properly and I get no such message
if I execute them with sqsh.

How do I tell DBI/DBD::Sybase that only fatal errors should be printed?

Regards,

Lars


-- 

----------------------------------------------------------------------
Lars Brueckner, Student of Computer Science
brueckne@darmstadt.gmd.de