2. ASPRunnerPro General questions
  3. Advanced Search Criteria - Drop Down
This topic is locked

Advanced Search Criteria - Drop Down

 		6/25/2007 4:36:51 PM
ASPRunnerPro General questions
S
 stealthwifi author

Hello,
I have a field called Target Date that is a dependant drop down box. The only criteria it gives to search for is "Equals". I need the Equals or is less then, and the other search criteria for this one.

I have attampted to go into report_search.asp and modify it and was able to get the criteira drop down to display and some of them work but the equals or less than is not owrking. If I use the quick search on the list page for this criteria and field it works perfectly. There are no error messages it jsut dosn't display any results when there are defiantly results.
Please Help!
Cheers,

Stealth
Sergey Kornilov admin 6/26/2007

Two changes are required in order to make it work. See my adjustments in bold:

  1. Open ..._search.asp file in text editor and find the section that belongs to this lookup field
    options=options & "<OPTION VALUE=""Equals"" " & s & ">" & "Equals" & "</option>"

    options=options & "<OPTION VALUE=""Equal or less than ..."" " & s & ">" & "Equal or less than ..." & "</option>"


2. Open include/commonfunctions.asp file and find Function StrWhereAdv

If GetEditFormat(strField,"") = EDIT_FORMAT_LOOKUP_WIZARD and strSearchOption<>"Equal or less than ..." Then


I hope this helps.