<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "http" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_connAbts_STRING Recordset1.Source = "SELECT firstName, lastName, memWebsite FROM tblMembers WHERE memWebsite LIKE '" + Replace(Recordset1__MMColParam, "'", "''") + "%' ORDER BY lastName ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 10 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> Artisans By The Sea - Gallery <% 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
Free Newsletter
Membership
Gallery
Resources
Contact
About Us
Free Newsletter
 

Many of our members are accomplished professionals. Here is a gallery of their websites and work!

<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
Members Websites
<%=(Recordset1.Fields.Item("firstName").Value)%> <%=(Recordset1.Fields.Item("lastName").Value)%> " target="_blank"><%=(Recordset1.Fields.Item("memWebsite").Value)%>

 

Stencil images are used with permissions by Melanie Royals of Royal Design

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