|
|
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
|
