<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
errorPage="error.jsp"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strCompanyName = "";
int intID = 0; // USE TO INDICATE IF TABLE IS EMPTY OF ANY CONTACT PERSON
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
byte bytBtnID = Byte.parseByte(request.getParameter("did"));
String [] arrCPID = request.getParameterValues("id");
/***** 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 Co_Name FROM tblCompanyInfo WHERE Co_ID=" + intCompanyID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) { // GET NAME OF COMPANY
strCompanyName = rs.getString("Co_Name");
}
SQLstmt = "DELETE FROM tblOtherCPs WHERE CPx_ID IN (0";
for (int i=0; i
Infinity
<% } %>