<% if not session("membership"&right(session.sessionid, 3))="Yes" then response.redirect("login.asp") %> <% page=request("page") if page="" or not isNumeric(page) then page=1 iPageSize = 12 iPageCurrent=cint(page) sTableName = "Catalog" strSQL = "SELECT * FROM " &sTableName& " order by category,indexNo,title" Set DataRec = Server.CreateObject("ADODB.RecordSet") DataRec.PageSize = iPageSize DataRec.CacheSize = iPageSize DataRec.Open strSQL, DataConn, adOpenKeyset, adLockPessimistic, adCmdText iPageCount = DataRec.PageCount if iPageCurrent > iPageCount then iPageCurrent = iPageCount if iPageCurrent < 1 then iPageCurrent = 1 %>
Electronic Library

<% if not iPageCount = 0 then DataRec.AbsolutePage = iPageCurrent else %> Download center will be coming soon. <% response.end end if %>
INSTRUCTIONS ON HOW TO DOWNLOAD:
To view files online, simply click the file names to launch Adobe Acrobat Reader. To download files, right click on the files names and select "Save target as". This will allow you to save files to your system.
<% if not iPageCount = 0 then DataRec.AbsolutePage = iPageCurrent iRecordsShown = 0 iColumn=0 bgcolor="EBEBEB" Categorytemp="" Do While iRecordsShown < iPageSize And Not DataRec.EOF ID=trim(Datarec("ID")) TITLE=trim(Datarec("TITLE")) DESCRIPTION=trim(Datarec("DESCRIPTION")) POSTDATE=trim(Datarec("POSTDATE")) category=datarec("category") Image1=datarec("image1") Image2=datarec("image2") if image1="" or isNull(datarec("image1")) then image1="download.gif" if not description = "" then if instr(ucase(description ),"") end if ' if len(description )>400 then description =left(description ,400)&" ..." end if if not Categorytemp=category then Categorytemp=category iColumn=0 bgcolor="EBEBEB" %> <% end if %> <% DataRec.MoveNext iRecordsShown = iRecordsShown + 1 iColumn=iColumn+1 if iColumn mod 2 = 0 then response.write "" bgcolor="" if iColumn mod 4 = 0 or iColumn mod 4 = 1 then bgcolor="EBEBEB" loop DataRec.Close Set DataRec = Nothing %>
<%=category%>
<%=title%> <%=Image2%>

*You will need Acrobat Reader to view the files above. Download it for free.