Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "pang khong lin" <klpang at hotmail dot com>
Subject: Re: updating of record
Date: Sep 16 1998 12:54AM

You are right, putting double qoutes does solve some of the problem. For 
the data types that are INT, there should not be any double qoutes and 
it worked even if the field is empty. In addition, CHAR is not a problem 
as long it is in double quote. But other data field like DATETIME and 
MONEY would need to insert double quotes and following the format ( that 
one chose ) exactly. 
Like "MM/DD/YYYY HH:MM:SS" or "00.00".

Hope this would help other newbies like me . . . and thanks Michael.

>pang khong lin writes:
> > hi all,
> > 
> > I am trying to insert a record to a database (Sybase) through a CGI 
> > script and i receive a lot of error message concerning error in data 
> > type. I managed to play around with the format of the data to 'suit' 
> > data type but still encounter some error message. 
> > 
> > For exp: Certain field of the record are empty or can be empty and 
> > seem that perl treat an empty field as a char. 
> > If anyone has come across these kind of problem, please advise.
>You're going to have to be a lot more specific than that if you want
>to get a coherent answer.
>Please provide some source code (as small as you can make it to still
>illustrate the problem) and a typical data set that causes the
>(off hand I would guess that you are placing quotes in the insert()
>statement where there shouldn't be any, or vice-versa...)
>Michael Peppler         -||-  Data Migrations Inc.
>       -||-
>Int. Sybase User Group  -||-

Get Your Private, Free Email at