2. ASPRunnerPro General questions
  3. [SOLVED]  Change Parameter Passed To A Page
This topic is locked
[SOLVED]

 Change Parameter Passed To A Page

 		2/8/2013 3:44:55 PM
ASPRunnerPro General questions
S
 solosoftware author

Hello Forum,
On my search page I have a list of values for a field (Paid, Unpaid, Delivered). however that field on the database only stores the first letter (P for Paid, U for Unpaid, D for Delivered)
When I select an option for that field, the application correctly passes the selected item from the list (for example Paid), however since only the first letter is stored on the database, there are no results to display.
The generated link is this:

"http://aplcation_web_site/TRANSAC_FISCAL_list.asp?q=%28STATUS~contains~Paid%29";
How and where can I pass the correct value from the search page (just the first letter) so the list page can return the values requested?
Thanks beforehand for your help
Sergey Kornilov admin 2/8/2013

If this field is configured as a Lookup wizard in your database you do not need to change anything - ASPRunnerPro will run a proper search automatically.
If you generate links manually simply make it appear as

http://aplcation_web_site/TRANSAC_FISCAL_list.asp?q=%28STATUS~contains~P%29
S
 		solosoftware author 2/8/2013

Thanks for the extremelly fast reply Sergey,
Is not from a list from the database, it's a "list of values" entered on the design of the search page.
Indeed, I need is to change the query of the page to say this:

"http://aplcation_web_site/TRANSAC_FISCAL_list.asp?q=(STATUS~contains~P)";
but I don't know where to do it, because by default the software selects the value from the list.

From the search page where do I tell it to use "P" instead of "Paid"?
Thanks



If this field is configured as a Lookup wizard in your database you do not need to change anything - ASPRunnerPro will run a proper search automatically.
If you generate links manually simply make it appear as

http://aplcation_web_site/TRANSAC_FISCAL_list.asp?q=%28STATUS~contains~P%29
Sergey Kornilov admin 2/9/2013

You need to change this Lookup wizard from list of values to database-based lookup wizard. That will solve all your issues.
S
 		solosoftware author 2/9/2013

Somehow I knew you will say that. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=69761&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

I tweaked with strWhereClause with some success, but I will change it to a DB table.

Thanks