Pear query error

From: Date: Mon, 19 May 2003 15:37:37 +0000
Subject: Pear query error
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-5440@lists.php.net to get a copy of this message
I'm getting a error in one of my pages. Its strange because it works fine on another system with the same database and same page. The message is: DB Error: unknown error. How can I get it to display more information. Here's the code that is the problem: // execute the query $query = "SELECT joblisting_id, requisition_no, joblisting.jobdescription_id, jobdescription.dept_id, dept_name, description, submitted_on, joblisting.submitted_by, vacancies, internal_only, joblisting.active, class_title, functional_title, file_name, year, entry_salary, max_salary FROM joblisting, jobdescription, department, salarygrade, salarygradeinfo WHERE joblisting.jobdescription_id = jobdescription.jobdescription_id AND jobdescription.dept_id = department.dept_id AND jobdescription.salarygrade_id = salarygrade.salarygrade_id AND salarygradeinfo.salarygrade_id = salarygrade.salarygrade_id AND joblisting.active = 'true' ORDER BY joblisting_id"; $result = $db->query($query); // Check the result object in case there was an error, and handle it here. if (DB::isError($result)) { die($result->getMessage()); } Like I said, this works properly on another machine and the query works from within PostgreSQL itself. Is there a way to change the debug level in PEAR? -- Jeff Self <jself@nngov.com> City of Newport News

« previous php.pear.general (#5440) next »