PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: problem with ct_send_data
Date: Jun 15 2000 5:31PM

Patrick S. Leung writes:
 > I modified one of my old update text scripts, and it didn't work
 > afterward.  The table has one text column,


 > 
 > And here is the error message:
 > 
 > Server message: (In srv_cb)
 > Message number: 156, Severity 15, State 1, Line 1
 > Server 'DEVELOP1'
 > Message String: Incorrect syntax near the keyword 'NULL'.
 > ...
 > (more errors below)

That looks like a problem with the fact that the data in the column is 
NULL initially (I think!).

Try setting the column to '' first, and see if that fixes the problem.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com