Hi, I would like to display an error message when the user name was already in use. I think this
if (document.frmUser.Username.value.toUpperCase() == "1BM1BM") {
alert("Username already in use");
return false; code doesn't work.
The database is user.mdb and the following code enters user's details into users.mdb and the username is the primary key the code is as follow:
<BASEFONT FACE="Comic Sans MS" COLOR="DarkBlue">
<HTML>
<HEAD>
<SCRIPT language="JavaScript">
<!--
function VerifyData()
{
// if (document.frmUser.Username.value == "" || document.frmUser.Password.value == "" ||
// document.frmUser.FirstName.value == "") {
// alert( "FirstName, Username or Password should not be blank" );
// return false;
// }
if (document.frmUser.Username.value.toUpperCase() == "1BM1BM") {
alert("Username already in use");
return false;
}
if (document.frmUser.EMailAddress.value == "" ||
document.frmUser.EMailAddress.value.indexOf ('@', 0) == -1) {
alert("Enter a valid email address")
document.frmUser.EMailAddress.focus()
return false;
}
if (document.frmUser.Password.value != document.frmUser.VerifyPassword.value) {
alert("Your passwords do not match - please reenter");
document.frmUser.Password.focus()
return false;
}
if (document.frmUser.Username.value.length < 5) {
alert("Username must be at least 5 characters")
document.frmUser.Username.focus()
return false;
}
if (document.frmUser.Password.value.length < 5) {
alert("Password must be at least 5 characters")
document.frmUser.Password.focus()
return false;
}
for (i=0; i<document.frmUser.length; i++)
if (document.frmUser.elements[i].value == "" ||
document.frmUser.elements[i].value == "Invalid") {
// prompt("***Not all fields are entered***","You must enter all fields")
alert("Not all fields are entered")
document.frmUser.elements[i].focus()
return false;
}
return true;
}
-->
</SCRIPT>
<TITLE>Register.asp: User Registration</TITLE>
</HEAD>
<BODY BGCOLOR="#ffffff">
<CENTER>
</CENTER>
<TABLE BORDER=0 WIDTH=100% BGCOLOR="e8f8f8">
<TR ALIGN=CENTER>
<TD><CENTER><H1>New User Registration</H1></CENTER></TD>
</TR>
</TABLE>
<CENTER>(If you're already registered with us, then click the 'Login' link below.)</CENTER><P>You only need to register with our system if you want to use the personalised digital library. <BR> In order to use these services, please take a few minutes to complete the form below. Once you have done that, you will have full access to the system.
<FORM ACTION="AddUser.asp" NAME="frmUser" METHOD="POST"
onSubmit="return VerifyData()">
<TABLE BORDER=0 Width= 100% BGCOLOR="LightBlue">
<TR>
<TD WIDTH=20% ROWSPAN=11> </TD>
<TD>First Name:</TD>
<TD><INPUT TYPE="Text" NAME="FirstName" VALUE="<%= Session("FirstName") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD>Last Name:</TD>
<TD><INPUT TYPE="Text" NAME="Surname" VALUE="<%= Session("Surname") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD>Address:</TD>
<TD><INPUT TYPE="Text" NAME="Address1" VALUE="<%= Session("Address1") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD></TD>
<TD><INPUT TYPE="Text" NAME="Address2" VALUE= "<%= Session("Address2") %>"
SIZE="40"> </TD>
</TR>
<TR>
<TD>City:</TD>
<TD><INPUT TYPE="Text" NAME="City" VALUE= "<%= Session("City") %>"
SIZE="40"> </TD>
<TR>
<TD>Post Code:</TD>
<TD><INPUT TYPE="Text" NAME="PostCode" VALUE="<%= Session("PostCode") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD>Country:</TD>
<TD><INPUT TYPE="Text" NAME="Country" VALUE="<%= Session("Country") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD>E-Mail Address:</TD>
<TD><INPUT TYPE="Text" NAME="EMailAddress" VALUE="<%= Session("EMailAddress") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD>User Name:</TD>
<TD><INPUT TYPE="Text" NAME="Username" VALUE="<%= Session("Username") %>"
SIZE="40"></TD>
</TR>
<TR>
<TD> <P>Password:</TD>
<TD VALIGN=bottom><INPUT TYPE="Password" NAME="Password" VALUE="<%= Session("Password") %>" SIZE="40"></TD>
</TR>
<TR>
<TD>Verify Password:</TD>
<TD><INPUT TYPE="Password" NAME="VerifyPassword" VALUE=""
SIZE="40"></TD>
</TR>
<TR>
<TD></TD>
<TD ALIGN=CENTER COLSPAN=2><BR>
<INPUT TYPE="Submit" VALUE="Submit Registration">
<INPUT TYPE="RESET"></TD>
</TR>
</TABLE>
</FORM>
<TABLE BORDER=0 WIDTH=100% BGCOLOR="#e8f8f8">
<TR ALIGN=CENTER>
<TD WIDTH=33%>Registration</TD>
<TD WIDTH=33%><A HREF="Login.asp">Login </A></TD>
<TD WIDTH=33%><A HREF="Browse.asp">Browse Libary </A></TD
</TR>
</TABLE>
</BODY>
</HTML>
I cannot display an error message
