• Home
 · 
• Active Server Pages
 · 
• Runs a Keyword Search in ASP

Runs a Keyword Search in ASP

Runs a Keyword Search in ASP

Rate Runs a Keyword Search in ASP

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

'You must Use a % instead of an * for use of a wilecard in ASP
'Created by SmartAddins.com


    Dim Conn 
    Dim RS
    Dim strSQL

    Set Conn = Server.CreateObject ("ADODB.Connection")
    Set RS = Server.CreateObject ("ADODB.Recordset")
	
    Conn.Open "DataODBCName"	
	
    strSQL = "SELECT tbl_Employee.Employee_Description" & _
	     " FROM tbl_Employee" & _
	     " WHERE (((tbl_Employee.Employee_Description)Like'%Joe%'))"   

    RS.Open (strSQL), Conn, adOpenStatic

    Do while Not RS.EOF
        Response.Write RS("Employee_Description") & "<BR>"
        RS.MoveNext
    Loop