|
|
|
<%
varSearchField = Request.Form("fndFirstSkill")
Dim objRec ' recordset object
Response.write "Your Search Field Was "
Response.write varSearchField & " " Response.write "These are the authors that match your selection criteria: " ' Note have an error catch if no authors match selection criteria! ' create the recordset object Set objRec = Server.CreateObject ("ADODB.Recordset") ' Now replace below code with SQL to just select and show the relevant authors. ' now open it objRec.Open "tblWriters", strConnect, adOpenForwardOnly, _ adLockReadOnly, adCmdTable ' now loop through the records While Not objRec.EOF Response.Write objRec("LastName") & ", " objRec.MoveNext Wend ' now close and clean up objRec.Close Set objRec = Nothing %> |
|
|