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: Dave Neill <dneill at POPMAIL dot UCSD dot EDU>
Subject: ct_fetchable question
Date: Oct 10 1998 10:23AM

The following code prints "NF - $fname $lname\n"; with every return - whether 
data is returned or not.  What am I doing wrong? (the SQL code was manually 
wrapped for readablity).

 	$X->ct_execute("select employee_number, first_name, last_name, 
  		department, title, phone_number, mail_code, email 
  		from phone..employee_view where lower(first_name) 
  		like lower(\"%$fname%\") and lower(last_name) like 
  		lower(\"%$lname%\") ");

		while($rc = $X->ct_results($restype) == CS_SUCCEED)
		{
  		if (!$X->ct_fetchable($restype)) {
 				print "NF - $fname $lname\n";
		}
Thanks,

Dave Neill