<%@ Page aspcompat=true %> <% Dim dbconnect, dbrecordset, sqlquery dbconnect = Server.CreateObject("ADODB.Connection") dbconnect.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("jiblm.mdb") & ";" dbconnect.Open dbrecordset = Server.CreateObject("ADODB.Recordset") Dim categoryvalue As String categoryvalue = Request.QueryString("category") sqlquery = "Select * From papers Where Category='" & categoryvalue & "' ORDER BY ID DESC" dbrecordset.Open(sqlquery, dbconnect) %> <% If categoryvalue="mathnerdscollection" %> JIBLM.org - MathNerds Course Guide Collection - Items Index <% Else If categoryvalue="guilfordjournal" %> JIBLM.org - Guilford Journal of Undergraduate Mathematics - Items Index <% Else If categoryvalue="jiblmjournal" %> JIBLM.org - Journal of Inquiry-Based Learning in Mathematics - Journal Contents <% Else %> JIBLM.org - Incorrect Request <% End If %> <% Dim rowcount As Integer, sumpages As Integer, key As Integer If categoryvalue="mathnerdscollection" %>

MathNerds Course Notes (Unrefereed)

These notes were donated to a collection originally gathered by MathNerds. Read the Unrefereed Course Notes page for more information.

This table is sortable. Click on a column heading to sort by that column. Click on a title to access the notes.

<% Do While Not dbrecordset.EOF rowcount = rowcount + 1 sumpages = sumpages + dbrecordset("Pages").Value %> <% dbrecordset.MoveNext Loop %>
Title Author Subject Pages

&category=<%=dbrecordset("Category").Value%>"> <%=dbrecordset("Title").Value%>

<%=dbrecordset("Author").Value%>

<%=dbrecordset("Subject").Value%>

<%=dbrecordset("Pages").Value%>


Number of documents: <%=rowcount%>
Total number of pages: <%=sumpages%>

<% Else If categoryvalue="guilfordjournal" %>

Guilford Course Notes (Unrefereed)

These notes were originally published by the Guilford College Journal of Undergraduate Mathematics as volumes in the Monographs on Undergraduate Mathematics series. Read the Unrefereed Course Notes page for more information.

This table is sortable. Click on a column heading to sort by that column. Click on a title to access the notes.

<% Do While Not dbrecordset.EOF rowcount = rowcount + 1 sumpages = sumpages + dbrecordset("Pages").Value %> <% dbrecordset.MoveNext Loop %>
Title Author Subject Pages Issue

&category=<%=dbrecordset("Category").Value%>"> <%=dbrecordset("Title").Value%>

<%=dbrecordset("Author").Value%>

<%=dbrecordset("Subject").Value%>

<%=dbrecordset("Pages").Value%>

<%=dbrecordset("Issue").Value%>


Number of documents: <%=rowcount%>
Total number of pages: <%=sumpages%>

<% Else If categoryvalue="jiblmjournal" %>

Journal Contents

These refereed course notes fulfill the guidelines listed under Information for Authors.

This table is sortable. Click on a column heading to sort by that column. Click on a title to access these notes.

<% Do While Not dbrecordset.EOF rowcount = rowcount + 1 sumpages = sumpages + dbrecordset("Pages").Value key = dbrecordset("SortKey").Value %> <% dbrecordset.MoveNext Loop %>
Title Author Subject Pages Issue

&category=<%=dbrecordset("Category").Value%>"> <%=dbrecordset("Title").Value%>

<%=dbrecordset("Author").Value%>

<%=dbrecordset("Subject").Value%>

<%=dbrecordset("Pages").Value%>

>

<%=dbrecordset("Issue").Value%>


Number of documents: <%=rowcount%>
Total number of pages: <%=sumpages%>

<% Else %>

Incorrect Request

Go to items index:

<% End If %> <% dbrecordset.Close dbconnect.Close %>