Calmaris
01-04-2004, 02:36 AM
I'm trying to call the script with a sub call this: dotheregistermember(Sender as Object, e as EventArgs)
if the user's name doesn't exist already. But I get an error
Compiler Error Message: BC30455: Argument not specified for parameter 'e' of 'Public Sub dotheregistermember(Sender As Object, e As System.EventArgs)'.
How Do I call the other sub?
<%@ Page Language="VBScript" Debug="true" aspcompat=true %>
<script runat="server">
Sub registermember (Sender as Object, e as EventArgs)
Try
Dim dbConn, dbQuery, recordsetDB, loginfound, User_Id,tstring
Dim Password, First_Name, Last_Name, Mem_City, Mem_Address, Postal_Code, Home_Phone_Num, Cell_Num, Marital_Status
Dim Occupation_School, Email_1, Email_2, Province, Country, State, Apt_Num, offlinenow
Dim namecheck, usernamecheck
User_Id = request.Form("User_Id")
Password = request.Form("Password")
First_Name = request.form("First_Name")
Last_Name = request.form("Last_Name")
Mem_City = request.form("City")
Mem_Address = request.form("Address")
Postal_Code=request.form("Postal_Code")
Home_Phone_Num=request.form("Home_Phone_Num")
Cell_Num=request.form("Cell_Num")
Marital_Status=request.form("Marital_Status")
Occupation_School=request.form("Occupation_School")
Email_1 = request.form("Email_1")
Email_2 = request.form("Email_2")
Province = request.form("Province")
State = request.form("State")
Apt_Num = request.form("Apt_Num")
Country = request.form("Country")
offlinenow = True
dbConn = Server.CreateObject("ADODB.Connection")
dbConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\mess\databases\members.mdb")
namecheck =" Select User_Id From Members WHERE User_Id = '" & User_Id & "' "
usernamecheck = dbconn.execute(namecheck)
If NOT usernamecheck.eof THEN
woops.Visible = true
ELSE
successful.visible = true
dotheregistermember(Sender as Object, e as EventArgs)
End if
Finally
End Try
</script>
<script runat="server">
Sub dotheregistermember (Sender as Object, e as EventArgs)
Try
tstring = " INSERT INTO Members ( User_Id, Password, First_Name, Last_Name, Mem_City, Mem_Address,Postal_Code, Home_Phone_Num, Cell_Num, Marital_Status, Occupation_School, Email_1, Email_2," & _
" Province, State, Apt_Num, Country, offlinenow)" & _
" VALUES ( '" & User_Id & "', '" & Password & "','" & First_Name & "','" & Last_Name & "','" & Mem_City & "', '" & Mem_Address & "', '" & Postal_Code & "', '" & Home_Phone_Num & "', " & _
" '" & Cell_Num & "', '" & Marital_Status & "', '" & Occupation_School & "', '" & Email_1 & "', '" & Email_2 & "', '" & Province & "', '" & State & "', '" & Apt_Num & "', '" & Country & "', True)"
recordsetDB = dbconn.execute(tstring)
'response.write("Thank you for Updating your Member Information")
'response.redirect("Home.aspx")
Finally
End Try
End sub
</script>
<html>
<head>
<title>Register</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>WELCOME TO THE REGISTRATION FORM</title>
</head>
<body background="grback.jpg">
<form method="Post" runat="Server"><p> </p>
<p>User Id<input type="text" name="User_Id" size="20"> Password <input type="Password" name="Password" size="20"></p>
<p>First Name <input type="Text" name="First_Name" size="20"> Last Name <input type="Text" name="Last_Name" size="20"></p>
<p>City <input type="Text" name="City" size="20">Address <input type="Text" name="Address" size="20">
<p>Occupation or School<input type="Text" name="Occupation_School" size="20">
Appt # <input type="Text" name="Apt_Num" size="20"><p>Province <input type="Text" name="Province" size="20">
Country <input type="Text" name="Country" size="20"></p>
<p>Cell Number <input type="Text" name="Cell_Num" size="20">
<p>Home Phone # <input type="Text" name="Home_Phone_Num" size="20">
Marital Status<input type="Text" name="Marital_Status" size="20"></p>
<p>Postal Code <input type="Text" name="Postal_Code" size="20">
<p>State<input type="Text" name="State" size="20">
<p>Email #1<input type="Text" name="Email_1" size="20"> Email #2 <input type="Text" name="Email_2" size="20"><p>
<input type="Submit" value="Submit" onserverclick="registermember" runat="Server"></form>
</body>
</html>
<asp:label id="successful" runat="server" visible="false">
You Have successfully Registered!!
<p><a href="Home.aspx" >Back to home page to log in!</a></p>
</asp:label>
<asp:panel id="woops" runat="server" Visible="False">
Someone Has already taken that you User Id..Try another one plz.
</asp:panel>
if the user's name doesn't exist already. But I get an error
Compiler Error Message: BC30455: Argument not specified for parameter 'e' of 'Public Sub dotheregistermember(Sender As Object, e As System.EventArgs)'.
How Do I call the other sub?
<%@ Page Language="VBScript" Debug="true" aspcompat=true %>
<script runat="server">
Sub registermember (Sender as Object, e as EventArgs)
Try
Dim dbConn, dbQuery, recordsetDB, loginfound, User_Id,tstring
Dim Password, First_Name, Last_Name, Mem_City, Mem_Address, Postal_Code, Home_Phone_Num, Cell_Num, Marital_Status
Dim Occupation_School, Email_1, Email_2, Province, Country, State, Apt_Num, offlinenow
Dim namecheck, usernamecheck
User_Id = request.Form("User_Id")
Password = request.Form("Password")
First_Name = request.form("First_Name")
Last_Name = request.form("Last_Name")
Mem_City = request.form("City")
Mem_Address = request.form("Address")
Postal_Code=request.form("Postal_Code")
Home_Phone_Num=request.form("Home_Phone_Num")
Cell_Num=request.form("Cell_Num")
Marital_Status=request.form("Marital_Status")
Occupation_School=request.form("Occupation_School")
Email_1 = request.form("Email_1")
Email_2 = request.form("Email_2")
Province = request.form("Province")
State = request.form("State")
Apt_Num = request.form("Apt_Num")
Country = request.form("Country")
offlinenow = True
dbConn = Server.CreateObject("ADODB.Connection")
dbConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\mess\databases\members.mdb")
namecheck =" Select User_Id From Members WHERE User_Id = '" & User_Id & "' "
usernamecheck = dbconn.execute(namecheck)
If NOT usernamecheck.eof THEN
woops.Visible = true
ELSE
successful.visible = true
dotheregistermember(Sender as Object, e as EventArgs)
End if
Finally
End Try
</script>
<script runat="server">
Sub dotheregistermember (Sender as Object, e as EventArgs)
Try
tstring = " INSERT INTO Members ( User_Id, Password, First_Name, Last_Name, Mem_City, Mem_Address,Postal_Code, Home_Phone_Num, Cell_Num, Marital_Status, Occupation_School, Email_1, Email_2," & _
" Province, State, Apt_Num, Country, offlinenow)" & _
" VALUES ( '" & User_Id & "', '" & Password & "','" & First_Name & "','" & Last_Name & "','" & Mem_City & "', '" & Mem_Address & "', '" & Postal_Code & "', '" & Home_Phone_Num & "', " & _
" '" & Cell_Num & "', '" & Marital_Status & "', '" & Occupation_School & "', '" & Email_1 & "', '" & Email_2 & "', '" & Province & "', '" & State & "', '" & Apt_Num & "', '" & Country & "', True)"
recordsetDB = dbconn.execute(tstring)
'response.write("Thank you for Updating your Member Information")
'response.redirect("Home.aspx")
Finally
End Try
End sub
</script>
<html>
<head>
<title>Register</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>WELCOME TO THE REGISTRATION FORM</title>
</head>
<body background="grback.jpg">
<form method="Post" runat="Server"><p> </p>
<p>User Id<input type="text" name="User_Id" size="20"> Password <input type="Password" name="Password" size="20"></p>
<p>First Name <input type="Text" name="First_Name" size="20"> Last Name <input type="Text" name="Last_Name" size="20"></p>
<p>City <input type="Text" name="City" size="20">Address <input type="Text" name="Address" size="20">
<p>Occupation or School<input type="Text" name="Occupation_School" size="20">
Appt # <input type="Text" name="Apt_Num" size="20"><p>Province <input type="Text" name="Province" size="20">
Country <input type="Text" name="Country" size="20"></p>
<p>Cell Number <input type="Text" name="Cell_Num" size="20">
<p>Home Phone # <input type="Text" name="Home_Phone_Num" size="20">
Marital Status<input type="Text" name="Marital_Status" size="20"></p>
<p>Postal Code <input type="Text" name="Postal_Code" size="20">
<p>State<input type="Text" name="State" size="20">
<p>Email #1<input type="Text" name="Email_1" size="20"> Email #2 <input type="Text" name="Email_2" size="20"><p>
<input type="Submit" value="Submit" onserverclick="registermember" runat="Server"></form>
</body>
</html>
<asp:label id="successful" runat="server" visible="false">
You Have successfully Registered!!
<p><a href="Home.aspx" >Back to home page to log in!</a></p>
</asp:label>
<asp:panel id="woops" runat="server" Visible="False">
Someone Has already taken that you User Id..Try another one plz.
</asp:panel>