This topic is locked

Advanced search parameter

11/12/2009 4:18:34 PM
ASPRunnerPro General questions
L
luic author

How can I get search parameters in ASPRunner 6.1? I tried the code you published for 5.2 (http://www.asprunner.com/forums/topic/5665-how-to-display-advanced-search-parameters-on-the-list-page/) and get the following error :
Type mismatch: 'SafeIsEmpty'
Chris.

J
Jane 11/13/2009

Chris,
you need to add SafeUsEmpty function to the After application initialized event:

http://www.xlinesoft.com/asprunnerpro/docs/after_application_initialized.htm

Function SafeIsEmpty(str)
if IsArray(str) then

SafeIsEmpty = false

Exit Function

end if
SafeIsEmpty = (str="")
End Function



Then use your code.

L
luic author 11/18/2009

Thanks. I can get the field names but how can I get the search input values?
Chris.

L
luic author 11/18/2009

I saw there are session variables like below. How can use it to get the search field name and field value? Examples please.
SESSION("<table name>_asearchnot")

Advanced search - array with NOT option value for each field
SESSION("<table name>_asearchopt")

Advanced search - array with search option value for each field (Equals, Contains etc)
SESSION("<table name>_asearchfor")

Advanced search - array with with search for value for each field
SESSION("<table name>_asearchfor2")

Advanced search - array with with second search for value for each field (Between search)

C
clig 11/18/2009



I saw there are session variables like below. How can use it to get the search field name and field value? Examples please.
SESSION("<table name>_asearchnot")

Advanced search - array with NOT option value for each field
SESSION("<table name>_asearchopt")

Advanced search - array with search option value for each field (Equals, Contains etc)
SESSION("<table name>_asearchfor")

Advanced search - array with with search for value for each field
SESSION("<table name>_asearchfor2")

Advanced search - array with with second search for value for each field (Between search)


the field name would be the actual name of your field - you could build a dynamic string appending values
short i.e.)
message="<a href=http://support/NTSS/NTSS_Tickets_Assign_list.asp?a=search&value=1&SearchOption=Equals&SearchField=TicketNo&SearchFor="; & Session("TicketNo") & ">Unassigned Queue</a>" & vbcrlf & "

Entered By (email): " & SESSION("UserIDEmail") & "<hr size=1>"

J
Jane 11/19/2009

Hi,
here is a sample:

SESSION("<table name>_asearchnot")("FieldName")
L
luic author 11/21/2009

I tried with this :
session("abc_Clients_asearchfor")("cl_fname")
and get an error like "Session(...)"
Chris.

J
Jane 11/24/2009

Chris,
It's difficult to tell you what's happening without seeing actual files.
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.