sybperl-l Archive

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