ASPRunner Professional 7.1 manual - Print search parameters on List page

If you want to search on the Advanced search page and then print search parameters on the List page, use the following code in List page: Before process event.

Note: Change the values listed in red to match your specific needs.

if not IsEmpty(Session(CSmartStr(strTableName) & "_advsearch")) then
doAssignmentByRef searchClauseObj,unserialize(Session(CSmartStr(strTableName) & "_advsearch"))
end if

doAssignment searchWhereClause,searchClauseObj.getWhere_p1(GetListOfFieldsByExprType(false, strTableName))
doAssignment searchHavingClause,searchClauseObj.getWhere_p1(GetListOfFieldsByExprType(true, strTableName))

doAssignment fieldSearchData, searchClauseObj.getSearchCtrlParams_p1("FieldName")
doAssignment fieldSearchData, searchClauseObj.var_where(strTableName & "_srchFields")

for i=0 to asp_count(fieldSearchData)-1
fName = fieldSearchData(i)("fName")
val1 = fieldSearchData(i)("value1")
val2 = fieldSearchData(i)("value2")
srchCat = fieldSearchData(i)("opt")
srchNot = fieldSearchData(i)("not")
Response.write "Search was completed." & "<br>"
Response.write "Search Field: " & fName & "<br>"
Response.write "Search Option: " & val1 & "<br>"
next