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: "Stern, Meir" <Meir dot Stern at gs dot com>
Subject: RE: ANNOUNCE: sybperl 2.11
Date: Sep 21 1999 10:04PM

Hi to all,

I am very new to CTlib I am trying to insert a record to a table in a sybase
database what is the best way to do it. This is my code I have written

$isql= "insert into Ticket_Entry values
(\"$DATE\",\"$FORM{'requiredfirstname'}\
",\"$FORM{'requiredlastname'}\",\"$FORM{'requiredphone'}\",\"$FORM{'building
'}\"
,$FORM{'floor'},\"$FORM{'priority'}\",\"$FORM{'y2k'}\",\"$FORM{'requiredprob
lem_
desc'}\",\"$FORM{'platform'}\",\"$FORM{'os'}\",\"$FORM{'requiredGroupSubmit'
}\",
\"$FORM{'requiredstatus'}\",\"$FORM{'requiredtracker'}\",\"$FORM{'ticketype'
}\")
";
$dbh = new Sybase::CTlib $user,$passwd,$SERVER,"undef" ;
print "got to here and this is $dbh \n";
$status = $dbh->ct_execute($sql);
while($dbh->ct_results($restype)==CS_SUCCEED)
{
        
        return $status;
}

This is the error I keep on getting
Open Client Message: Message number: LAYER = (1) ORIGIN = (1) SEVERITY = (1)
NUMBER = (136) Message String: ct_command(LANG): user api layer:
external error: A string of length 0 is not allowed for parameter buf. Open
Client Message: Message number: LAYER = (1) ORIGIN = (1) SEVERITY = (1)
NUMBER = (155) Message String: ct_results(): user api layer: external error:
This routine cannot be called when the command structure is idle.
Content-type:text/html got to here and this is Sybase::CTlib=HASH(0x19711c)
got to the execute command this is 

PLEASE HELP!!!!! Thanks a lot in advance.


Meir Stern
Dept: User Support Engineering
Tel: 71727
Email: meir.stern@ny.email.gs.com



-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Tuesday, September 21, 1999 5:36 PM
To: SybPerl Discussion List
Subject: ANNOUNCE: sybperl 2.11


The uploaded file

    sybperl-2.11.tar.gz

has entered CPAN as

  file: $CPAN/authors/id/MEWP/sybperl-2.11.tar.gz
  size: 164518 bytes
   md5: 2441a76c126d9f7265ad9996b94bbca1

This is mostly a bug fix release - making sure that most of the fixes
that I have applied or received since the 2.10_02 release get out.

>From the CHANGES file:

2.11	Various bug fixes.

	nsql() patch from W. Philipp Moore.
	Added EMBED_SYBASE configuration variable.
	dbreadtext() could cause a core dump if the internal call failed.
	Figured out what was needed to get Sybase::DBlib to talk to an 
	MS-SQL 7 dataserver. Sybase::CTlib still does not work with the
	normal, non-patched MS-SQL 7 server.
	Fixed bug 261: Money/Numeric potentially lose precision in
		       Sybase::CTlib.

2.10_02
	Fix incorrect dropping of locale structure in CTlib::DESTROY.
	Link pod/sybperl.pod to CTlib/CTlib.pod and DBlib/DBlib.pod so 
	that perldoc Sybase::DBlib now works.

2.10_01

	Added dbbylist().
	Added DBIORDESC() and DBIOWDESC() (contributed by David Worenklein)
	Modifications to nsql() contributed by W. Phillip Moore.
	Added minimal support for languages and charsets to Sybase::CTlib.

Enjoy!

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