Back to Results Not Working

1/04/2013 9:20 am | #1 Mike Perry

Running 1.1.12, CS6, Windows 7 Pro 64 bit.

Created a full set of admin pages. Search Results Recordset is based on the following:

SELECT id, distName, distState
FROM distributors
WHERE distState = st OR distName LIKE nm%

Recordset fills correctly.

If I click on the Detail icon the Details page shows correctly. However the Back to Results button takes me to an Empty Results page.

The code for the Back to Results button is:

<td><input type="button" value="Back To Results" class="formButton Sharp" id="BackToResults" name="BackToResults" onclick="document.location.href = 'distresults.php<?php echo(isset($_GET["pageNum_WADAdistributors"])?"?pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?>';" /></td>

pageNum_WADAdistribitors is not bound anywhere, and the url for the empty Results page has no criteria in it.

Help??

Thanks,

Mike

1/04/2013 9:31 am | #3 Mike Perry

Originally Said By: Jason Byrnes

send a copy of the details and results pages please.

Hi Jason -- Happy New Year !

Here ya go. . .

Attached Files

lig2012.zip

1/04/2013 10:11 am | #4 Jason ByrnesWebAssist

change the code for the links to the details page:

php:

<a href="distdetail.php?id=<?php echo($row_WADAdistributors['id']); ?><?php echo(isset($_GET["pageNum_WADAdistributors"])?"&pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?>" >

to:

php:

<a href="distdetail.php?id=<?php echo($row_WADAdistributors['id']); ?><?php echo(isset($_GET["pageNum_WADAdistributors"])?"&pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?><?php echo(isset($_GET["distState"])?"&distState=".$_GET["distState"]:""); ?><?php echo(isset($_GET["distName"])?"&distName=".$_GET["distName"]:""); ?>" >

on the details page, change the code for the back to results button:

php:

<input type="button" value="Back To Results" class="formButton Sharp" id="BackToResults" name="BackToResults" onClick="document.location.href = 'distresults.php<?php echo(isset($_GET["pageNum_WADAdistributors"])?"?pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?>';" />

to:

php:

<input type="button" value="Back To Results" class="formButton Sharp" id="BackToResults" name="BackToResults" onClick="document.location.href = 'distresults.php<?php echo(isset($_GET["pageNum_WADAdistributors"])?"?pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?><?php echo(isset($_GET["distState"])?"&distState=".$_GET["distState"]:""); ?><?php echo(isset($_GET["distName"])?"&distName=".$_GET["distName"]:""); ?>';" />

1/07/2013 4:58 am | #5 Mike Perry

Originally Said By: Jason Byrnes

change the code for the links to the details page:

php:

<a href="distdetail.php?id=<?php echo($row_WADAdistributors['id']); ?><?php echo(isset($_GET["pageNum_WADAdistributors"])?"&pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?>" >

to:

php:

<a href="distdetail.php?id=<?php echo($row_WADAdistributors['id']); ?><?php echo(isset($_GET["pageNum_WADAdistributors"])?"&pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?><?php echo(isset($_GET["distState"])?"&distState=".$_GET["distState"]:""); ?><?php echo(isset($_GET["distName"])?"&distName=".$_GET["distName"]:""); ?>" >

on the details page, change the code for the back to results button:

php:

<input type="button" value="Back To Results" class="formButton Sharp" id="BackToResults" name="BackToResults" onClick="document.location.href = 'distresults.php<?php echo(isset($_GET["pageNum_WADAdistributors"])?"?pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?>';" />

to:

php:

<input type="button" value="Back To Results" class="formButton Sharp" id="BackToResults" name="BackToResults" onClick="document.location.href = 'distresults.php<?php echo(isset($_GET["pageNum_WADAdistributors"])?"?pageNum_WADAdistributors=".intval($_GET["pageNum_WADAdistributors"]):""); ?><?php echo(isset($_GET["distState"])?"&distState=".$_GET["distState"]:""); ?><?php echo(isset($_GET["distName"])?"&distName=".$_GET["distName"]:""); ?>';" />

Hi Jason --

This fixed the links in the Results table and Detail Page -- however the top & bottom record paging nav buttons on the Results page are not operational, and if I view a record using the record Detail button on Results the Return to Results also fails. . .

Return to Results also fails after an update. Update Page attached.

Thanks. . .

ETA: Found the Nav button problem. Relocated the code that defines $queryString_WADAdistributors so that it follows the recordset definition. . .

Attached Files

distupdate.zip

1/07/2013 12:45 pm | #6 Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Back to Results Not Working

1/04/2013 9:20 am | #1 Mike Perry