Search/Results page not returning results

This is the 2nd time this has happened to me. I go through the wizards, and create a Search screen on the Results page. When I try to perform a search, nothing happens. No errors, just no results are returned. Then when I try to re-run the search wizard, I get an error that says I must create a recordset first, even though one HAS been created, but it is not visible in the Bindings panel. I am attaching my page of code. Thank you.

Have you tried the new version of data bridge that was released yesterday, v1.0.6?

This version has a fix for a bug we discovered in Data Assist search where the recordset is not showing in the bindings panel like you describe. Make sure to uninstall the previous version before installing the newer one.

Thanks, Jason. I'll try that first and let you know if it works or not.

I deleted the previous version and installed the new one, but the recordset still isn't showing up in the Bindings panel and the search wizard won't recognize it. Any suggestions without having to recreate all of the associated pages again? Thanks!

try adding a space between line 88 and 89. change 88-89:

$row_WADAjobs = mysql_fetch_assoc($WADAjobs);

if (isset($_GET['totalRows_WADAjobs'])) {

to:

$row_WADAjobs = mysql_fetch_assoc($WADAjobs);



if (isset($_GET['totalRows_WADAjobs'])) {

Didn't make any difference, unfortunately.

there also needs to be a line between 81- 82:

$startRow_WADAjobs = $pageNum_WADAjobs * $maxRows_WADAjobs;

mysql_select_db($database_timesheets, $timesheets);

should be:

$startRow_WADAjobs = $pageNum_WADAjobs * $maxRows_WADAjobs;



mysql_select_db($database_timesheets, $timesheets);

yu may need to save and reopen the page after making the change to see the recordset.

Crap. The recordset is still not there and I did close and reopen the page. I may just end up recreating the page. Hopefully, not the entire set of pages, as they have been customized. Hopefully, with the new version install, this won't happen again :)

Ok, let us know if you continue to have problems, and I will start an incident.