This topic is locked

How to print search parameters on the list page

6/4/2010 4:24:00 AM
ASPRunnerPro Tips and tricks
J
Jane author

Let's say you want to search on the Advanced search page and then print search parameters on the list:

Search was completed.

Search Field: Fieldname

Search Option: 123


Use List page: Before display event on the Events tab for this purpose. Here is a sample:

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." & "
"

Response.write "Search Field: " & fName & "
"

Response.write "Search Option: " & val1 & "
"

next