|
 |
access_asp thread: Script won't populate database
Message #1 by "Jim Losi" <jlosi1@t...> on Thu, 30 Aug 2001 04:55:07
|
|
hello,
I'm very new to ASP, infact I've only been "coding" for 4 days. I am
trying to write a simple script that will populate my access database.
Essentially it's a signup form. i will paste code in sections as they are
separate .asp pages in themselves.
The final issue is this: When the script runs, I am able to see the data
but the database will not populate even though the ID is incremented +1
every time.
[Begin code]
<!--Dim page for variables-->
<%
Dim
strFirstName,strLastName,strNick,strEmail,strStreet,strCity,strState,intZip
,intAreacode,intPhprefix,intPhsuffix,strDeposit,datAttendingDate
FirstName=request.form ("FirstName")
LastName=request.form ("LastName")
Street=request.form ("Street")
City=request.form ("City")
State=request.form ("State")
Zip=request.form ("Zip")
AreaCode=request.form ("AreaCode")
Phprefix=request.form ("Phprefix")
Phsuffix=request.form ("Phsuffix")
Deposit=request.form ("Deposit")
AttendingDate=request.form ("AttendingDate")
Nick=request.form ("Nick")
Email=request.form ("Email")
%>
<!--Connection-->
<%
Dim MyConn
Dim RS
Set MyConn = Server.CreateObject ("ADODB.Connection")
Set RS = Server.CreateObject ("ADODB.Recordset")
MyConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\attendance.mdb;"
%>
<!--signup initial info-->
<HTML>
<head>
<title>Signup Form</title>
</head>
<body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
<!-- Sign up form user data collection-->
<form action="signupconfirm.asp" method="post">
First Name: <input type="str" name="FirstName">
<br>
Last Name: <input type="str" name="LastName">
<br>
Nick Name: <input type="str" name="Nick">
<br>
Email: <input type="str" name="Email">
<br>
Street: <input type="str" name="Street">
<br>
City: <input type="str" name="City">
<br>
State:
<select size="1" name="State">
<option value=" ">Choose Your State</option>
<option value="Alaska">Alaska</option>
<option value="Alabama">Alabama</option>
<option value="Arkansas">Arkansas</option>
<option value="Arizona">Arizona</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Iowa">Iowa</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option
value="Massachusetts">Massachusetts</option>
<option value="Maryland">Maryland</option>
<option value="Maine">Maine</option>
<option value="Michigan">Michigan </option>
<option value="Minnesota">Minnesota</option>
<option value="Missouri">Missouri</option>
<option value="Mississippi">Mississippi </option>
<option value="Montana">Montana</option>
<option value="North Carolina">North
Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Nebraska">Nebraska</option>
<option value="New Hampshire">New
Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="Nevada">Nevada</option>
<option value="New York">New York</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvania">Pennsylvania</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South
Carolina</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Virginia">Virginia</option>
<option value="Vermont">Vermont</option>
<option value="Washington">Washington</option>
<option value="Wisconsin">Wisconsin</option>
<option value="West Virginia ">West Virginia
</option>
<option value="Wyoming">Wyoming </option>
</select>
<br>
Phone Number<input type="int" name="Areacode" size="3"> - <input
type="int" name="Phprefix" size="3"> - <input type="int" name="Phsuffix"
size="4">
<br>
<br>
Please select the date you will be attending:
<select size="1" name="AttendingDate">
<option value="10-28-2001">10-28-2001</option>
</select>
<br>
The Total cost of attendance is $20.00 US Currency.
Please choose if you will be paying your $10.00 in advance and $10.00 at
the door or Paying the full $20.00 in advance : <select size="1"
name="Deposit">
<option value="10.00">$10.00</option>
<option value="20.00">$20.00</option>
</select>
<br>
Please note that this will lock your spot and is <font color="red"><b>non
refundable</b></font> so please show up if you decide to attend!
<br><br>
<input type="Submit" value="Submit Information">
</form>
</body>
</html>
<!--Signup info confirmation-->
<!--#include file="Dim_page.asp"-->
<form action="signup.asp" name="Users" method="post">
First Name: <input type="str" Name="FirstName" value="<%
response.write FirstName%>">
<br>
Last Name: <input type="str" name="LastName" value="<%
response.write LastName%>">
<br>
Nick Name: <input type="str" name="Nick" value="<%
response.write Nick%>">
<br>
Email: <input type ="str" name="Email" value="<%
response.write Email%>">
<br>
Street: <input type="str" Name="Street" value="<%
response.write Street%>">
<br>
City: <input type="str" name= "City" value="<%response.write
City%>">
<br>
State:
<select size="1" name="State">
<option value="<%response.write state%>"><%
response.write state%></option>
<option value="Alaska">Alaska</option>
<option value="Alabama">Alabama</option>
<option value="Arkansas">Arkansas</option>
<option value="Arizona">Arizona</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Iowa">Iowa</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option
value="Massachusetts">Massachusetts</option>
<option value="Maryland">Maryland</option>
<option value="Maine">Maine</option>
<option value="Michigan">Michigan </option>
<option value="Minnesota">Minnesota</option>
<option value="Missouri">Missouri</option>
<option value="Mississippi">Mississippi </option>
<option value="Montana">Montana</option>
<option value="North Carolina">North
Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Nebraska">Nebraska</option>
<option value="New Hampshire">New
Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="Nevada">Nevada</option>
<option value="New York">New York</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvania">Pennsylvania</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South
Carolina</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Virginia">Virginia</option>
<option value="Vermont">Vermont</option>
<option value="Washington">Washington</option>
<option value="Wisconsin">Wisconsin</option>
<option value="West Virginia ">West Virginia
</option>
<option value="Wyoming">Wyoming</option>
</select>
<br>
Phone Number
<input type="int" name="Areacode" value="<%response.write Areacode%>"
size="3"> -
<input type="int" name="Phprefix" value="<%response.write Phprefix%>"
size="3"> -
<input type="int" name="Phsuffix" value="<%response.write Phsuffix%>"
size="4">
<br>
<br>
Please select the date you will be attending:
<select size="1" name="AttendingDate">
<option value="<%response.write AttendingDate%>"><%response.write
AttendingDate%></option>
<option value="LAN1">10-28-2001</option>
</select>
<br>
The Total cost of attendance is $20.00 US Currency.
Please choose if you will be paying your $10.00 in advance and $10.00 at
the door or Paying the full $20.00 in advance :
<select size="1" name="Deposit">
<option value="<%response.write Deposit%>"><%response.write
Deposit%></option>
<option value="10.00">$10.00</option>
<option value="20.00">$20.00</option>
</select>
<br>
Please note that this will lock your spot and is <font color="red"><b>non
refundable</b></font> so please show up if you decide to attend!
<br>
<br>
<input type="Submit" value="Confirm Information">
</form>
<!--final info submission after confirmation:populate-->
<!--#include file="Dim_page.asp"-->
<!--#include file="Connection.asp"-->
<!--#include file="adovbs.inc"-->
<%
RS.Open "tblLAN", MyConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
RS.AddNew
RS("FirstName")= request.form ("strFirstName")
RS("LastName")= request.form ("strLastName")
RS("Nick")=request.form ("strNick")
RS("Email")=request.form ("strEmail")
RS("Street")= request.form ("strStreet")
RS("City")=request.form ("strCity")
RS("State")= request.form ("strState")
RS("Areacode")=request.form ("intAreacode")
RS("Phprefix")=request.form ("intPhprefix")
RS("Phsuffix")=request.form ("intPhsuffix")
RS("Deposit")=request.form ("intDeposit")
RS("AttendingDate")=request.form ("datAttendingDate")
RS.Update
RS.Close
MyConn.Close
Set RS = Nothing
Set MyConn = Nothing
response.write FirstName
response.write LastName
response.write Street
response.write City
response.write State
response.write areacode
response.write Phprefix
response.write Phsuffix
response.write Deposit
response.write Nick
response.write AttendingDate
response.write Email
%>
[End code]
That's it. I'm sure it's quite simple to you wizards out there ;) Any help
on why the db (acess) will not populate would be appreciated greatly!
Thanks in advance.
Message #2 by "Jim Losi" <jlosi1@t...> on Thu, 30 Aug 2001 12:53:09
|
|
I have fixed my error thanks to some outside help. He informed me that I
was using the wrong variable to call.. I had to call "FirstName" and
not "strFirstName". Thank you.
> hello,
> I'm very new to ASP, infact I've only been "coding" for 4 days. I am
> trying to write a simple script that will populate my access database.
> Essentially it's a signup form. i will paste code in sections as they
are
> separate .asp pages in themselves.
> The final issue is this: When the script runs, I am able to see the data
> but the database will not populate even though the ID is incremented +1
> every time.
>
> [Begin code]
> <!--Dim page for variables-->
>
> <%
> Dim
>
strFirstName,strLastName,strNick,strEmail,strStreet,strCity,strState,intZip
> ,intAreacode,intPhprefix,intPhsuffix,strDeposit,datAttendingDate
>
>
>
> FirstName=request.form ("FirstName")
> LastName=request.form ("LastName")
> Street=request.form ("Street")
> City=request.form ("City")
> State=request.form ("State")
> Zip=request.form ("Zip")
> AreaCode=request.form ("AreaCode")
> Phprefix=request.form ("Phprefix")
> Phsuffix=request.form ("Phsuffix")
> Deposit=request.form ("Deposit")
> AttendingDate=request.form ("AttendingDate")
> Nick=request.form ("Nick")
> Email=request.form ("Email")
> %>
>
>
>
> <!--Connection-->
> <%
> Dim MyConn
> Dim RS
> Set MyConn = Server.CreateObject ("ADODB.Connection")
> Set RS = Server.CreateObject ("ADODB.Recordset")
> MyConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Inetpub\wwwroot\attendance.mdb;"
> %>
>
> <!--signup initial info-->
>
>
> <HTML>
> <head>
> <title>Signup Form</title>
> </head>
>
>
> <body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
>
> <!-- Sign up form user data collection-->
>
>
> <form action="signupconfirm.asp" method="post">
> First Name: <input type="str" name="FirstName">
> <br>
> Last Name: <input type="str" name="LastName">
> <br>
> Nick Name: <input type="str" name="Nick">
> <br>
> Email: <input type="str" name="Email">
> <br>
> Street: <input type="str" name="Street">
> <br>
> City: <input type="str" name="City">
> <br>
> State:
> <select size="1" name="State">
> <option value=" ">Choose Your State</option>
> <option value="Alaska">Alaska</option>
> <option value="Alabama">Alabama</option>
> <option value="Arkansas">Arkansas</option>
> <option value="Arizona">Arizona</option>
> <option value="California">California</option>
> <option value="Colorado">Colorado</option>
> <option value="Connecticut">Connecticut</option>
> <option value="Delaware">Delaware</option>
> <option value="Florida">Florida</option>
> <option value="Georgia">Georgia</option>
> <option value="Hawaii">Hawaii</option>
> <option value="Iowa">Iowa</option>
> <option value="Idaho">Idaho</option>
> <option value="Illinois">Illinois</option>
> <option value="Indiana">Indiana</option>
> <option value="Kansas">Kansas</option>
> <option value="Kentucky">Kentucky</option>
> <option value="Louisiana">Louisiana</option>
> <option
> value="Massachusetts">Massachusetts</option>
> <option value="Maryland">Maryland</option>
> <option value="Maine">Maine</option>
> <option value="Michigan">Michigan </option>
> <option value="Minnesota">Minnesota</option>
> <option value="Missouri">Missouri</option>
> <option value="Mississippi">Mississippi </option>
> <option value="Montana">Montana</option>
> <option value="North Carolina">North
> Carolina</option>
> <option value="North Dakota">North Dakota</option>
> <option value="Nebraska">Nebraska</option>
> <option value="New Hampshire">New
> Hampshire</option>
> <option value="New Jersey">New Jersey</option>
> <option value="New Mexico">New Mexico</option>
> <option value="Nevada">Nevada</option>
> <option value="New York">New York</option>
> <option value="Ohio">Ohio</option>
> <option value="Oklahoma">Oklahoma</option>
> <option value="Oregon">Oregon</option>
> <option value="Pennsylvania">Pennsylvania</option>
> <option value="Rhode Island">Rhode Island</option>
> <option value="South Carolina">South
> Carolina</option>
> <option value="Tennessee">Tennessee</option>
> <option value="Texas">Texas</option>
> <option value="Utah">Utah</option>
> <option value="Virginia">Virginia</option>
> <option value="Vermont">Vermont</option>
> <option value="Washington">Washington</option>
> <option value="Wisconsin">Wisconsin</option>
> <option value="West Virginia ">West Virginia
> </option>
> <option value="Wyoming">Wyoming </option>
> </select>
>
> <br>
> Phone Number<input type="int" name="Areacode" size="3"> - <input
> type="int" name="Phprefix" size="3"> - <input type="int" name="Phsuffix"
> size="4">
> <br>
> <br>
> Please select the date you will be attending:
> <select size="1" name="AttendingDate">
> <option value="10-28-2001">10-28-2001</option>
> </select>
>
> <br>
>
> The Total cost of attendance is $20.00 US Currency.
> Please choose if you will be paying your $10.00 in advance and $10.00
at
> the door or Paying the full $20.00 in advance : <select size="1"
> name="Deposit">
> <option value="10.00">$10.00</option>
> <option value="20.00">$20.00</option>
> </select>
> <br>
> Please note that this will lock your spot and is <font
color="red"><b>non
> refundable</b></font> so please show up if you decide to attend!
>
> <br><br>
> <input type="Submit" value="Submit Information">
>
> </form>
> </body>
> </html>
>
>
> <!--Signup info confirmation-->
> <!--#include file="Dim_page.asp"-->
>
>
>
> <form action="signup.asp" name="Users" method="post">
> First Name: <input type="str" Name="FirstName" value="<%
> response.write FirstName%>">
> <br>
> Last Name: <input type="str" name="LastName" value="<%
> response.write LastName%>">
> <br>
> Nick Name: <input type="str" name="Nick" value="<%
> response.write Nick%>">
> <br>
> Email: <input type ="str" name="Email" value="<%
> response.write Email%>">
> <br>
> Street: <input type="str" Name="Street" value="<%
> response.write Street%>">
> <br>
> City: <input type="str" name= "City" value="<%response.write
> City%>">
> <br>
> State:
> <select size="1" name="State">
> <option value="<%response.write state%>"><%
> response.write state%></option>
> <option value="Alaska">Alaska</option>
> <option value="Alabama">Alabama</option>
> <option value="Arkansas">Arkansas</option>
> <option value="Arizona">Arizona</option>
> <option value="California">California</option>
> <option value="Colorado">Colorado</option>
> <option value="Connecticut">Connecticut</option>
> <option value="Delaware">Delaware</option>
> <option value="Florida">Florida</option>
> <option value="Georgia">Georgia</option>
> <option value="Hawaii">Hawaii</option>
> <option value="Iowa">Iowa</option>
> <option value="Idaho">Idaho</option>
> <option value="Illinois">Illinois</option>
> <option value="Indiana">Indiana</option>
> <option value="Kansas">Kansas</option>
> <option value="Kentucky">Kentucky</option>
> <option value="Louisiana">Louisiana</option>
> <option
> value="Massachusetts">Massachusetts</option>
> <option value="Maryland">Maryland</option>
> <option value="Maine">Maine</option>
> <option value="Michigan">Michigan </option>
> <option value="Minnesota">Minnesota</option>
> <option value="Missouri">Missouri</option>
> <option value="Mississippi">Mississippi </option>
> <option value="Montana">Montana</option>
> <option value="North Carolina">North
> Carolina</option>
> <option value="North Dakota">North Dakota</option>
> <option value="Nebraska">Nebraska</option>
> <option value="New Hampshire">New
> Hampshire</option>
> <option value="New Jersey">New Jersey</option>
> <option value="New Mexico">New Mexico</option>
> <option value="Nevada">Nevada</option>
> <option value="New York">New York</option>
> <option value="Ohio">Ohio</option>
> <option value="Oklahoma">Oklahoma</option>
> <option value="Oregon">Oregon</option>
> <option value="Pennsylvania">Pennsylvania</option>
> <option value="Rhode Island">Rhode Island</option>
> <option value="South Carolina">South
> Carolina</option>
> <option value="Tennessee">Tennessee</option>
> <option value="Texas">Texas</option>
> <option value="Utah">Utah</option>
> <option value="Virginia">Virginia</option>
> <option value="Vermont">Vermont</option>
> <option value="Washington">Washington</option>
> <option value="Wisconsin">Wisconsin</option>
> <option value="West Virginia ">West Virginia
> </option>
> <option value="Wyoming">Wyoming</option>
> </select>
>
> <br>
> Phone Number
> <input type="int" name="Areacode" value="<%response.write Areacode%>"
> size="3"> -
> <input type="int" name="Phprefix" value="<%response.write Phprefix%>"
> size="3"> -
> <input type="int" name="Phsuffix" value="<%response.write Phsuffix%>"
> size="4">
>
> <br>
> <br>
>
> Please select the date you will be attending:
>
> <select size="1" name="AttendingDate">
> <option value="<%response.write AttendingDate%>"><%response.write
> AttendingDate%></option>
> <option value="LAN1">10-28-2001</option>
>
> </select>
>
> <br>
>
> The Total cost of attendance is $20.00 US Currency.
> Please choose if you will be paying your $10.00 in advance and $10.00
at
> the door or Paying the full $20.00 in advance :
>
> <select size="1" name="Deposit">
> <option value="<%response.write Deposit%>"><%response.write
> Deposit%></option>
> <option value="10.00">$10.00</option>
> <option value="20.00">$20.00</option>
> </select>
>
> <br>
>
> Please note that this will lock your spot and is <font
color="red"><b>non
> refundable</b></font> so please show up if you decide to attend!
>
> <br>
> <br>
>
> <input type="Submit" value="Confirm Information">
>
> </form>
>
>
> <!--final info submission after confirmation:populate-->
> <!--#include file="Dim_page.asp"-->
> <!--#include file="Connection.asp"-->
> <!--#include file="adovbs.inc"-->
>
> <%
> RS.Open "tblLAN", MyConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
> RS.AddNew
> RS("FirstName")= request.form ("strFirstName")
> RS("LastName")= request.form ("strLastName")
> RS("Nick")=request.form ("strNick")
> RS("Email")=request.form ("strEmail")
> RS("Street")= request.form ("strStreet")
> RS("City")=request.form ("strCity")
> RS("State")= request.form ("strState")
> RS("Areacode")=request.form ("intAreacode")
> RS("Phprefix")=request.form ("intPhprefix")
> RS("Phsuffix")=request.form ("intPhsuffix")
> RS("Deposit")=request.form ("intDeposit")
> RS("AttendingDate")=request.form ("datAttendingDate")
> RS.Update
>
> RS.Close
> MyConn.Close
> Set RS = Nothing
> Set MyConn = Nothing
>
> response.write FirstName
> response.write LastName
> response.write Street
> response.write City
> response.write State
> response.write areacode
> response.write Phprefix
> response.write Phsuffix
> response.write Deposit
> response.write Nick
> response.write AttendingDate
> response.write Email
> %>
>
>
> [End code]
>
> That's it. I'm sure it's quite simple to you wizards out there ;) Any
help
> on why the db (acess) will not populate would be appreciated greatly!
> Thanks in advance.
|
|
|
View Cart
