<% openConn() 'Our query holds ID and name columns from the tblsubject. DIM objfldID, objfldName 'create connection object Dim objCmd', objRS set objCmd = Server.CreateObject("ADODB.Command") set objRS = Server.CreateObject("ADODB.RecordSet") set objCmd.ActiveConnection = objConn '--- the command will be executed later on in the script: As will the record set be created if the retval is not -1. objCmd.CommandText = "{? = call pbs_list_lessons_between_grade_ids(?,?)}" objCmd.Parameters.Append objCmd.CreateParameter("RetVal", 3, 4, 0) objCmd.Parameters.Append objCmd.CreateParameter("startGradeValue", 3, 1, 0,request.QueryString("sval")) objCmd.Parameters.Append objCmd.CreateParameter("endGradeValue", 3, 1, 0,request.QueryString("eval")) objRS.open objCmd set objfldlessonTitle = objRS("title") set objfldGradeStart = objRS("startGrade") set objfldGradeEnd = objRS("endGrade") set objfldoverview = objRS ("overview") set objfldFileName = objRS("pdfHref") set objfldID = objRS("ID") set objYopFld = objRs("yearOfPublication") set objIsGrant = objRs("isGrant") 'set objfldSubject = objRS("subject") set tmpObjRS = Server.CreateObject("ADODB.RecordSet") function getOverview(strID) strReturnValue="" tmpObjRS.open "SELECT overview FROM tblLessons WHERE ID = " & strID, objConn, 1, 3 if not objRS.EOF then strReturnValue = tmpObjRS("overview") end if tmpObjRS.close getOverview = strReturnValue end function %> WVPT4Learning - Lesson Plans WVPT4Learning - Lesson Plans
  <%If AudType=1 OR AudType=7 OR AudType=6 Then%> <%Else%> <%End If%>
<% if AudType =1 then%>
 
<%else%>
 
<%end if%>

<%=objfldSubject%>

To access PDF files of NTTI lessons, click on your choice of title.

<% function buildGradeLevel(startGrade, endGrade) returnValue = "" if startGrade="" then returnValue = "" elseif (startGrade=endGrade OR endGrade="") then returnValue = "(" & startGrade & ")" else returnValue = "(" & startGrade & " - " & endGrade & ")" end if buildGradeLevel = returnValue end function function buildFullOverview(rs, memoFieldName) returnValue = "" ''This construct shoudl change to Do while control structure ''mainChunk = overviewField.GetChunk(4000) 'returnValue = mainChunk ''Do Until IsNull(mainChunk) '' mainChunk = overviewField.GetChunk(4000) '' returnValue = returnValue & mainChunk ''Loop mainChunk = rs.Fields(memoFieldName).GetChunk(4000) returnValue = mainChunk Do Until IsNull(mainChunk) mainChunk = rs.Fields(memoFieldName).GetChunk(4000) returnValue = returnValue & mainChunk Loop buildFullOverview = returnValue end function Do until objRS.EOF %>

<%=objfldlessonTitle%> <%=buildGradeLevel(objfldGradeStart,objfldGradeEnd)%>
<% If (objYopFld=null or isNull(objYopFld)) then if objIsGrant then Response.write(objfldoverview & " (SVTC NTTI Participant Lesson)") else Response.write(objfldoverview & " (NTTI Master Teacher Lesson)") end if else if objIsGrant then Response.write(objfldoverview & " (" &objYopFld&" SVTC NTTI Participant Lesson)") else Response.write(objfldoverview & " (" &objYopFld&" NTTI Master Teacher Lesson)") end if end if %>

<% Response.flush objRS.movenext Loop set objfldGradeStart = nothing set objfldGradeEnd = nothing set objfldlessonTitle = nothing set objfldname = nothing set objfldoverview = nothing set objfldID = nothing set objRS = nothing 'set objconn = nothing %>

 

 
 
<% set objconn = nothing %>