<% 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 %>