close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Search/Results page not returning results

Thread began 7/24/2012 9:23 pm by sandy170299 | Last modified 7/27/2012 11:40 am by Jason Byrnes | 919 views | 8 replies |

sandy170299

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.

Attached Files
jobs_results.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

sandy170299

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

Sign in to reply to this post

sandy170299

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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

php:
$row_WADAjobs = mysql_fetch_assoc($WADAjobs);

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




to:

php:
$row_WADAjobs = mysql_fetch_assoc($WADAjobs);


if (isset($_GET['totalRows_WADAjobs'])) {
Sign in to reply to this post

sandy170299

Didn't make any difference, unfortunately.

Sign in to reply to this post

Jason ByrnesWebAssist

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

php:
$startRow_WADAjobs = $pageNum_WADAjobs * $maxRows_WADAjobs;

mysql_select_db($database_timesheets, $timesheets);




should be:

php:
$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.

Sign in to reply to this post

sandy170299

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 :)

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...