<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strPageID = "memcpeditj"; // USE TO IDENTIFY MESSAGE ON tmpTblMessages IF BELONGS TO THIS PAGE
String [] arrCPID, arrCPFName, arrCPLName, arrCPPos, arrCPDept, arrCPEMail;
String [] arrCPTArea, arrCPTNum, arrCPTLoc;
boolean [] cpEmpty;
int ctr = 0;
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
/***** END OF VARIABLE DECLARATION *****/
String SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";";
users.connect(strMainDB);
ResultSet rs = users.listQuery(SQLstmt);
byte bytLogStatus = 0;
while (rs.next()) {
bytLogStatus = rs.getByte("LogOnStatus");
}
if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE
%>
<%
} else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE
SQLstmt = "SELECT * FROM tmpTblOtherCPs WHERE Co_ID=" + intCompanyID + " ORDER BY CPx_ID;";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
ctr++; // COUNTS TOTAL NUMBER OF CONTACT PERSONS
}
arrCPID = new String[ctr];
arrCPFName = new String[ctr];
arrCPLName = new String[ctr];
arrCPPos = new String[ctr];
arrCPDept = new String[ctr];
arrCPTArea = new String[ctr];
arrCPTNum = new String[ctr];
arrCPTLoc = new String[ctr];
arrCPEMail = new String[ctr];
cpEmpty = new boolean[ctr];
rs.beforeFirst();
ctr = 0;
while (rs.next()) {
arrCPID[ctr] = rs.getString("CPx_ID");
arrCPFName[ctr] = rs.getString("CPx_FirstN");
arrCPLName[ctr] = rs.getString("CPx_LastN");
arrCPPos[ctr] = rs.getString("CPx_Position");
arrCPDept[ctr] = rs.getString("CPx_Dept");
arrCPTArea[ctr] = rs.getString("CPx_TelArea");
arrCPTNum[ctr] = rs.getString("CPx_TelNum");
arrCPTLoc[ctr] = rs.getString("CPx_TelLocal");
arrCPEMail[ctr] = rs.getString("CPx_EMail");
ctr++;
}
for (int i=0; i
Contact Person - Update Successful
errorPage="error.jsp"
<% } // END OF LOG CHECK %>