%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_waldorf_STRING
MM_waldorf_STRING = "dsn=waldorf;uid=marin;pwd=waldorf0;"
%>
<%
Dim newsletter
Dim newsletter_numRows
Set newsletter = Server.CreateObject("ADODB.Recordset")
newsletter.ActiveConnection = MM_waldorf_STRING
newsletter.Source = "SELECT * FROM newsletters ORDER BY listNumber DESC"
newsletter.CursorType = 0
newsletter.CursorLocation = 2
newsletter.LockType = 1
newsletter.Open()
newsletter_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 1
Repeat1__index = 0
newsletter_numRows = newsletter_numRows + Repeat1__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = 10
Repeat2__index = 0
newsletter_numRows = newsletter_numRows + Repeat2__numRows
%>
Newsletters for the Marin Waldorf School Community
@2003 Marin Waldorf School, All Rights Reserved.
Site Designed by Seymour
Designs
<%
newsletter.Close()
Set newsletter = Nothing
%>