<%@ LANGUAGE="VBSCRIPT" %> <% '-- Global Variables -- blnNeedRs = False ' True: Create New Recordset blnEmptyRs = False ' True: Database Query Returned empty recordset adMaximumShow = 30 ' Maximum show on page strFilename = Request.ServerVariables("PATH_INFO") strnameParts = Split(strFilename,"/") strFilename = strnameParts(UBound(strnameParts)) Dim PageNmr_aa ' -- Retrieve Page Parameters ' determine the current page number strPageNmr = FormatTextHTML(request.QueryString("Page")) If strPageNmr = "" Then If IsEmpty(PageNmr_aa) Then intPageNmr = 1 Else intPageNmr = PageNmr_aa End If Else intPageNmr = CInt(strPageNmr) PageNmr_aa = intPageNmr End If strSort = FormatTextHTML(request.QueryString("Sort")) Select Case strSort Case "State": strSortBy = "State" End Select Dim avar_Reports_aa Dim SortType_aa If IsEmpty(avar_Reports_aa) Then blnNeedRs = True ElseIf SortType_aa <> strSort Then blnNeedRs = True End If '-- Open Database Connection -- If blnNeedRs Then Set rs = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT DISTINCT State FROM " & TABLE_NAME & " WHERE Status =" & adLive & " AND Hold = 0 " rs.Open strSQL, CONNECTION_STRING, 3, 3 If NOT (rs.EOF AND rs.BOF) Then avarReports = rs.GetRows() Else blnEmptyRs = True End If avar_Reports_aa = avarReports SortType_aa = strSort Else avarReports = avar_Reports_aa End If 'On Error Resume Next If NOT blnEmptyRs Then intTotalPages = Fix((UBound(avarReports,2) + 1)/adMaximumShow) If UBound(avarReports,2) + 1 mod adMaximumShow <> 0 Then intTotalPages = intTotalPages + 1 End If End If Response.Buffer = True Response.Expires = 0 %> News Writing With Scholastic Editors <% doMenu %>










Read Student Writing    
<% 'Display Current page of total pages If FormatTextHTML(request("Page")) <> "" then ' Is there Page # passed? Page = FormatTextHTML(request("Page")) ' Yes, there is If IsNumeric(Page) then Page = Int(Page) Else If intTotalPages > 1 Then intPageNmr = 1 End If PageURL = "readsch.asp" 'strPageTitle = "Administration Page" If FormatTextHTML(request("rand"))= NULL or FormatTextHTML(request("rand")) = "" then rndnum = rnd else rndnum = FormatTextHTML(request("rand"))+ 1 end if If intTotalPages > 1 Then Response.Write "Page: " & intPageNmr & " of " & intTotalPages End If %>
<% '****** Generate page(s) link (30 records per each page) *********** If NOT blnEmptyRs Then ' -- JUMP TO PAGE linkS -- If intTotalPages > 1 Then 'Generate pages only if find more than 30 records If (intPageNmr > 1) then Response.Write "<<Previous " End If For intI = 1 To intTotalPages If intI <> intPageNmr Then Response.Write " | " & intI & " " Else Response.Write " | " & intI & " " End If Next Response.Write "|" If ((intTotalPages > 1) and (intPageNmr < intTotalPages)) then Response.Write " Next>>" End If End If End If %>

To read student writing, find and click on the name of the state in the list below.

<% If NOT blnEmptyRs Then If intPageNmr <> intTotalPages Then intRepShow = adMaximumShow Else intRepShow = UBound(avarReports,2) - (intPageNmr-1)*adMaximumShow + 1 End If intShift = (intPageNmr - 1) * adMaximumShow For intLoop = intShift To intRepShow + intShift - 1 Response.Write "• " & avarReports(0,intLoop) & "
" Next Else Response.Write "

Come back soon to see what kids have written!

" End If %>


 
<% doFooter %>