| 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 : |
<!--- CoursePrerequisiteList.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 Department_1.DepartmentCode, Course_1.CourseNumber
FROM (Department AS Department_1 INNER JOIN Course AS Course_1 ON Department_1.DepartmentID = Course_1.DepartmentID) INNER JOIN ((Course INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) INNER JOIN Course_Prerequisite ON Course.CourseID = Course_Prerequisite.CourseID) ON Course_1.CourseID = Course_Prerequisite.PrerequisiteID
WHERE (((Department.DepartmentCode)='#DepartmentCode#') AND ((Course.CourseNumber)='#CourseNumber#'))
</pre></cfoutput>
</cfif>
<cfquery datasource="#APPLICATION.DATASOURCE_RC#"
name="CoursePrerequisiteList">
SELECT Department_1.DepartmentCode, Course_1.CourseNumber
FROM (Department AS Department_1 INNER JOIN Course AS Course_1 ON Department_1.DepartmentID = Course_1.DepartmentID) INNER JOIN ((Course INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) INNER JOIN Course_Prerequisite ON Course.CourseID = Course_Prerequisite.CourseID) ON Course_1.CourseID = Course_Prerequisite.PrerequisiteID
WHERE (((Department.DepartmentCode)='#DepartmentCode#') AND ((Course.CourseNumber)='#CourseNumber#'))
</cfquery>
<cfif CoursePrerequisiteInfoDebug AND REMOTE_ADDR eq "127.0.0.1">
<cfoutput>PrerequisiteCourses.RecordCount=#PrerequisiteCourses.RecordCount#<br></cfoutput>
</cfif>