2. ASPRunnerPro General questions
  3. Go directly to Advanced Search from Menus
This topic is locked

Go directly to Advanced Search from Menus

 		2/5/2009 12:53:53 PM
ASPRunnerPro General questions
J
 Jkelleyus author

This question has been asked in different ways, but here's what I want to do:
When a user arrives at the main menu, or is navigating via button in other list pages, I want the user to be directed to the Advanced Search page for certain list.
I'm querying large tables in an AS400 (which take a lot of time) and need the user to be able to query only the records they need, which makes things quite faster.
Thanks for the help. ASPRunner is working beautifully for this project, and I've used PHPRunner for many MySQL projects. The two sre absolutely awesome, as is the support and on-going improvements.
Jake
J
 		Jane 2/6/2009

Jake,
use List page: Before process event on the Events tab for this purpose.

Here is just a sample:

if request.querystring("a")<>"advsearch" and request.querystring("a")<>"search" then

Response.Redirect "TableName_search.asp"

end if
J
 		Jkelleyus author 2/6/2009

Jane,
Thanks for your answer. However, this code merely returns to the Advanced Search page when the serach is completed.
In other word, when you select your search criteria, the query runs for 10 seconds and then just returns back to the Advanced Search page.
Any other ideas?
Jake
J
 		Jane 2/9/2009

Jake,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
J
 		Jkelleyus author 2/9/2009

Jane,
Thanks for the reply.
I am using ASPR (build 766) and I don't find a button to download to the demo account anymore (after the build page). The choices are View in Browser, Open output folder, Publish via FTP, Publish via Frontpage, and Quick upload to InspiRunner.com.
How do I upload this project to you? I can use FTP if necessary.
Jake
J
 		Jane 2/13/2009

Jake,
Please zip project directory, your project and database and open a ticket at http://support.xlinesoft.com sending your files along with instructions on reproducing this error.
C
 		clig 6/3/2009

This question has been asked in different ways, but here's what I want to do:

When a user arrives at the main menu, or is navigating via button in other list pages, I want the user to be directed to the Advanced Search page for certain list.
I'm querying large tables in an AS400 (which take a lot of time) and need the user to be able to query only the records they need, which makes things quite faster.
Thanks for the help. ASPRunner is working beautifully for this project, and I've used PHPRunner for many MySQL projects. The two sre absolutely awesome, as is the support and on-going improvements.
Jake


set a session var when session started (login) / check state of var in list page / set zero records initial display / remove standard search / redirect based on the value of that var / change var onload of advanced search...
the first attempt to load the list page will send you to advanced search - all subsequent searches would have be done from advanced search but the list page would display results...