Display Search by Network (ex. Cisco) or All Projects in the MS Access Table

[hotflash]

Hi All,

Below is a GOOD working script that I use to search for the record either by the MOP ID for example 1, 2, etc... (record on the database) or by Network for example when you type Cisco.

What I would like to do and is having problem is to either Search by Network or All MOP IDs on the database (show all records). Let's say if folks type in ALL, it will show all of the MOP IDs (Records) in the database. Thanks advance for your help.

<%
Dim strNetwork
Dim strMOPID
Dim Conn
Dim strSQL
Dim RS
 
strNetwork = trim(Request.Form("Network"))
strMOPID = trim(Request.Form("MOPID"))
If len(strNetwork)=0 then
    strNetwork=0
End if
 
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
 
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("MOPsCentral.mdb")
 
If isNumeric(strNetwork) then
    strSQL = "Select * FROM MOPs WHERE MOPID=" & strNetwork
Else
    strSQL = "Select * FROM MOPs WHERE Network='" & strNetwork & "' ORDER BY MOPID"
End If
 
RS.Open strSQL, Conn
 
If RS.EOF Then
   Response.Redirect("SearchMOPs.asp?MOPError=Sorry ... Your MOP ID or Network does not exist in our database.  Please try again.")
End If
%>

[hotflash]

Hi CroCrew,

Thanks for your oustanding support. I have sent you an email with 2 attachments.