Pear query error
| From: | Jeff Self | 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