<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_connVBI_STRING Recordset1.Source = "SELECT * FROM catalog" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>

id	FirstName	LastName	Address1	Address2	City	State	Zip	Phone	Email	Language
<%=(Recordset1.Fields.Item("id").Value)%>	<%=(Recordset1.Fields.Item("fname").Value)%>	<%=(Recordset1.Fields.Item("lname").Value)%>	<%=(Recordset1.Fields.Item("add1").Value)%>	<%=(Recordset1.Fields.Item("add2").Value)%>	<%=(Recordset1.Fields.Item("city").Value)%>	<%=(Recordset1.Fields.Item("state").Value)%>	<%=(Recordset1.Fields.Item("zip").Value)%>	<%=(Recordset1.Fields.Item("phone").Value)%>	<%=(Recordset1.Fields.Item("email").Value)%>	<%=(Recordset1.Fields.Item("language").Value)%>

<% Recordset1.Close() Set Recordset1 = Nothing %>