by Eddy B (3 Submissions)
Category: Active Server Pages
Compatability: ASP (Active Server Pages)
Difficulty: Unknown Difficulty
Originally Published: Mon 26th February 2001
Date Added: Mon 8th February 2021
Rating: (1 Votes)
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