<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% DIM objRS DIM strSQL Set objRS = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT tblTest.* FROM tblTest WHERE tblTest.testActive = 'inactive';" objRS.Open strSQL,objConn %> <% DO WHILE NOT objRS.EOF %> <% objRS.MoveNext LOOP %>

ID		First Name		Surname		Email Address
" target="_parent"><%=objRS("id_test")%>		<%=objRS("testName")%>		<%=objRS("testSurname")%>		<%=objRS("testEmail")%>

<% objRS.Close Set objRS = Nothing Set objConn = Nothing %>