Runs a Keyword Search in ASP

by Eddy B (3 Submissions)
Category: Active Server Pages
Compatability: ASP (Active Server Pages)
Difficulty: Unknown Difficulty
Originally Published: Mon 26^th February 2001
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate Runs a Keyword Search in ASP



'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

Download this snippet Add to My Saved Code

Runs a Keyword Search in ASP Comments

No comments have been posted about Runs a Keyword Search in ASP. Why not be the first to post a comment about Runs a Keyword Search in ASP.

Runs a Keyword Search in ASP

Runs a Keyword Search in ASP Comments

Post your comment

Difficulty