%
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
%>
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
%>