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: problems using ct_param()
Date: Nov 21 2001 5:10PM

Ashley writes:
 > I was wondering if any one has used the ct_param() function call much , I am
 > trying to implement a simple cgi script to execute the stored procedure
 > sp_who with a users name.
 > 
 > $dbh->ct_command(CS_RPC_CMD, "sp_who", 6, CS_NO_RECOMPILE);
 > %parm = (name => '@loginame', datatype => CS_CHAR_TYPE, status =>
 > CS_INPUTVALUE, value => '$formdata{username}', indicator => CS_UNUSED);
 > $dbh->ct_param(\%param);

Using "strict" might have helped.

You have %parm and %param in the code above, which means you're
passing an empty hash to the ct_param() call...

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com