Multiple Key Column Search in _list.php page

Gordon,
you can process this type of search manually in the List page: Before SQL query event on theEvents tab.

Here is just a sample:

Hello,
I have the same question, but for ASPRunner any idea how I should approach this in as the code below gives an error.

Microsoft VBScript compilation error '800a0408'

Invalid character

/Dev/15jan/15-jan3/include/Tool_Table_07_TVA_events.asp, line 23

if (@$_REQUEST["a"]==search" && $_REQUEST["SearchOption"]=="IN")

----^
and will the below works like: http://livedemo.aspr...st.php?a=search&SearchFor=ANATR,ALFKI

etc.?
thanks a lot in advance
Erik

So, if I want to pass this - how would I modify the search string? Using the example above where I pass a comma delimited list? How can I modify the WHERE clause in the code?

Gordon,
here is just a sample:

Erik,
you need to convert PHP code to ASP:

Jane,
Thanks I have added this to the event, I had to remove the " after search to get this working.

I am desperate looking for the code to get the following working but without luck sofar.

?a=search&SearchOption=IN&SearchField=Control%20ID&SearchFor=01.01.01,01.01.02,01.02.02, etc
Could you help me to solve the issue to provide the results for 01.01.01 and 01.01.02 and 01.02.02 etc depending on the url?

This is the showstopper before golive for me.
regards,

Erik

Got it working in the end, the following did the trick for me:
<%

' List page: Before SQL query

Function BeforeQueryList(ByRef strSQL,ByRef strWhereClause,ByRef strOrderBy)
dim countArg

dim strISSArg

dim strTemp
strISSArg = SPLIT(REQUEST("CntlSelection"), ",")
IF UBound(strISSArg) > 0 then

strWhereClause = whereAdd(strWhereClause, "Control_ID='" & strISSArg(0)& "' ")

countArg = 1

END IF
WHILE countArg <= UBound(strISSArg)

strWhereClause = strWhereClause & "OR Control_ID='" & strISSArg(countArg) & "' "

countArg = countArg + 1

WEND

TRIM(strWhereClause)
End Function ' BeforeQueryList

arrAvailableEvents("BeforeQueryList")=true

%>