Events Page of Lorna Kelly: Auctioneer and Author

<%@LANGUAGE="VBSCRIPT"%> <% set events = Server.CreateObject("ADODB.Recordset") events.ActiveConnection = MM_yuk_STRING events.Source = "SELECT * FROM events WHERE dateEvent >= Date() ORDER BY dateEvent ASC" events.CursorType = 0 events.CursorLocation = 2 events.LockType = 3 events.Open() events_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = 10 Dim Repeat1__index Repeat1__index = 0 events_numRows = events_numRows + Repeat1__numRows %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> Events Page of Lorna Kelly: Auctioneer and Author

I'm so happy you have visited this electronic meeting place. If you like, please read some of the entries listed here to see what Lorna has been up to. Thanks!

<% While ((Repeat1__numRows <> 0) AND (NOT events.EOF)) %> valign="top" align="left"> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 events.MoveNext() Wend %>

Date: <%=(events.Fields.Item("dateEvent").Value)%> Time: <%=(events.Fields.Item("timeEvent").Value)%> Location: <%=(events.Fields.Item("locationEvent").Value)%>, <%=(events.Fields.Item("city").Value)%>, <%=(events.Fields.Item("state").Value)%>	"><%=(events.Fields.Item("titleEvent").Value)%>

Lorna Kelly

Site by www.elizintl.com

<% events.Close() %>