<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim rsFullMemberInfo Dim rsFullMemberInfo_cmd Dim rsFullMemberInfo_numRows Set rsFullMemberInfo_cmd = Server.CreateObject ("ADODB.Command") rsFullMemberInfo_cmd.ActiveConnection = MM_connAbts_STRING rsFullMemberInfo_cmd.CommandText = "SELECT City, email, firstName, lastName, otherPhone, phone, [State], streetAddress, Zip FROM tblMembers ORDER BY lastName ASC" rsFullMemberInfo_cmd.Prepared = true Set rsFullMemberInfo = rsFullMemberInfo_cmd.Execute rsFullMemberInfo_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsFullMemberInfo_numRows = rsFullMemberInfo_numRows + Repeat1__numRows %> ABTS2.jpg <% Const IMGS_DIR = "/abts/topPics/" Dim objFSO, objFolderObject, objFileCollection, objFile Dim intFileNumberToUse, intFileLooper Dim objImageFileToUse Dim strImageSrcText Set objFSO = Server.CreateObject("Scripting.FileSystemObject") Set objFolderObject = objFSO.GetFolder(Server.MapPath(IMGS_DIR)) Set objFSO = Nothing Set objFileCollection = objFolderObject.Files Set objFolderObject = Nothing Randomize() intFileNumberToUse = Int(objFileCollection.Count * Rnd) + 1 intFileLooper = 1 For Each objFile in objFileCollection If intFileLooper = intFileNumberToUse Then Set objImageFileToUse = objFile Exit For End If intFileLooper = intFileLooper + 1 Next Set objFileCollection = Nothing strImageSrcText = IMGS_DIR & objImageFileToUse.Name Set objImageFileToUse = Nothing %>

flower decoration
Artisans By The Sea
Members Only
 

Login

Members ' information

Administrators
Only

Back to Main Site

 

 

 

List All Members

<% While ((Repeat1__numRows <> 0) AND (NOT rsFullMemberInfo.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsFullMemberInfo.MoveNext() Wend %>

Name

Phone

Email

Address

City

State

Zip
<%=(rsFullMemberInfo.Fields.Item("lastName").Value)%>, <%=(rsFullMemberInfo.Fields.Item("firstName").Value)%> <%=(rsFullMemberInfo.Fields.Item("phone").Value)%> <%=(rsFullMemberInfo.Fields.Item("email").Value)%> <%=(rsFullMemberInfo.Fields.Item("streetAddress").Value)%> <%=(rsFullMemberInfo.Fields.Item("City").Value)%> <%=(rsFullMemberInfo.Fields.Item("State").Value)%> <%=(rsFullMemberInfo.Fields.Item("Zip").Value)%>

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