<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, users.databases.*" %> Log On Test <% /**** VARIABLE DECLARATION and INITIALIZATION *****/ String strNewName = request.getParameter("userLogName"); /***** MAIN *****/ String SQLstmt = "SELECT Usr_LogName FROM tblUserPwd"; strNewName = strNewName.toLowerCase(); if (foundInvalidChar(strNewName)) { withError = true; } else { users.connect(strMainDB); ResultSet rs = users.listQuery(SQLstmt); while (rs.next()) { String strName = rs.getString("Usr_LogName"); strName = strName.toLowerCase(); if (strName.equals(strNewName)) { strFoundAtDB = "mainDB"; invalidName = true; existingUser = true; withError = true; break; } } users.disconnect(); if (invalidName==false) { users.connect(strTempDB); rs = users.listQuery(SQLstmt); while (rs.next()) { String strName = rs.getString("Usr_LogName"); strName = strName.toLowerCase(); if (strName.equals(strNewName)) { strFoundAtDB = "tempDB"; invalidName = true; existingUser = true; withError = true; break; } } users.disconnect(); } } %>
         

Company Registration

 
<% if (existingUser) { %>

If you are an EXISTING SUBSCRIBER and want to add a different company information or you REGISTERED before but did not finish, please press the press the YES button.

<% } %> <% } %>
 

Copyright © 2001-2003 by Grafikoncepts and Designs, Inc.
A joint project of Grafikoncepts and Designs, Inc. and Digital Management and Solutions, Inc.
Layout by MVMG (VPIT), Digital Management and Solutions, Inc.