DA Search Wizard in Data Bridge not finding recordset
I have the following recordset, which joins 4 tables together. I need to display the data from all four of these tables, but when I try to apply the WebAssist >> Database >> DataAssist Search Wizard, I get an error message that says: Please insert a recordset to use Database Search. The recordset also does not show up in my bindings panel anymore once I started joining tables together. Help? Here is the recordset:
$colname_WADAemployeesxjobsxlaborcodes = "-1";
if (isset($_SESSION['companyID'])) {
$colname_WADAemployeesxjobsxlaborcodes = $_SESSION['companyID'];
}
mysql_select_db($database_timesheets, $timesheets);
$query_WADAemployeesxjobsxlaborcodes = sprintf("SELECT employeesxjobsxlaborcodes.ID, employees.lname, employees.fname, employeesxjobsxlaborcodes.dateWorked, employeesxjobsxlaborcodes.hoursWorked, jobs.jobNumber, laborcodes.laborCode, employees.payRate, employees.companyID
FROM ((employeesxjobsxlaborcodes INNER JOIN laborcodes ON employeesxjobsxlaborcodes.laborCodeID = laborcodes.laborCodeID) INNER JOIN jobs ON employeesxjobsxlaborcodes.jobID = jobs.jobID) INNER JOIN employees ON employeesxjobsxlaborcodes.employeeID = employees.employeeID WHERE employees.companyID = %s ORDER BY employees.lname, employees.fname, employeesxjobsxlaborcodes.dateWorked DESC", GetSQLValueString($colname_WADAemployeesxjobsxlaborcodes, "int"));
