The information from the form on my website won't add to my database.

**Ennis** · 11-11-2004 10:14 PM

I have this problem and don't know what it is....can anyone help. None of the information from the form that is typed in is being added to the database. and i dn't know why. The Database is opened, and thje source is set in the include.asp page.

Code:

<link rel="stylesheet" type="text/css" href="styles.css"/>
<!-- #include file = "Include.asp" -->
<!-- #include file = "Adovbs.inc" -->
<html>
<HEAD>
<title>
</title>
</HEAD>
<body>
<FORM ACTION="database.htm">
<INPUT TYPE = SUBMIT VALUE="Return to Database Page">
</FORM>
<%
Phone=request.form("Phone")
FirstName=request.form("FirstName")
LastName=request.form("LastName")
Address=request.form("Address")
city=request.form("city")
province=request.form("province")
PostalCode=request.form("PostalCode")
%>

<%
strQuery = "Insert into Contacts (Phone, FirstName, LastName, Address, City, province, PostalCode) values ('"& Phone &"', '"& FirstName &"', '"& LastName &"','"& Address &"','"& city &"', '"& province &"', '"& PostalCode &"')"

oC.open cs
oCM.ActiveConnection = oC
oCM.CommandText = strQuery
oCM.CommandType = adCmdText
oCM.Execute
response.write(strQuery)
oC.close
set oC=nothing
%>
<p> The Current Records are in the Database:</p>
<br>
<% oRS.open "Select * from Contacts", cs %>

<table border = "0" width="100%">
<tr><td>Phone</td>
    <td>First Name</td>
    <td>Last Name</td>
    <td>Address</td>
    <td>City</td>
    <td>Province</td>
    <td>Postal</td>
<tr>
<% do while not oRS.EOF %>
<tr>
	<td><% = oRS("Phone") %></td>
	<td><% = oRS("FirstName") %></td>
	<td><% = oRS("LastName") %></td>
	<td><% = oRS("Address") %></td>
	<td><% = oRS("City") %></td>
	<td><% = oRS("province") %></td>
	<td><% = oRS("PostalCode") %></td>
</tr>
<% oRS.movenext
loop

oRS.close
set oRS = nothing
%>
</table>

</body>
</html>

**russell** · 11-11-2004 11:16 PM

do you get any errors? if so what do they say. what do you get on this line:

response.write(strQuery)

Which, by the way, should be:

response.write strQuery

**Ennis** · 11-12-2004 07:21 AM

i don't get any errors. Im writing the code out of notepad and then just changing the code to a html file.

**lmf232s** · 11-12-2004 10:00 AM

I dont do updates like this but this might be it.
Try this

oCM.Execute(strQuery)

you currently have

oCM.Execute

I think you have to supply it a variable (sql query) to execute.

also put this line at the top of you page.

<%option explicit%>

This would of made it error out. With out this your page will not error out.
You will have to declare all variables but this is good programming practice.

**russell** · 11-12-2004 12:19 PM

Make it an asp file, not an html file.

oCM.Execute is the correct syntax. This is a command object, not a connection object.

**Ennis** · 11-12-2004 01:35 PM

im confused.

the code above is in asp. The database connects to the asp page after the button is clicked.

**russell** · 11-12-2004 01:39 PM

writing the code out of notepad and then just changing the code to a html file.

Are you saving it with an .asp extension?

Did you do a Response.Write strQuery? What did it write out?

Make sure there are no "On Error Resume Next" in the file, or the include file.

What does the web browser show after the form is posted?

Right-click and View Source of the web page. Scroll to the last line. Any errors there, that maybe dont show up in the displayed html?

**lmf232s** · 11-12-2004 01:40 PM

Im writing the code out of notepad and then just changing the code to a html file.

russell is saying you need to save it with a .asp extension and not a .htm extension.

Damn russell your fast, i looked at it typed it and then i saw your post, lol.

damn you posted another reply while i was editing this one, lol

**russell** · 11-12-2004 01:41 PM

note that if you are saving it with an HTM or HTML extension, none of your asp will be parsed.

**russell** · 11-12-2004 01:51 PM

Hmmm lmf, I wonder if you are typing right now...

**Ennis** · 11-12-2004 02:58 PM

There is an include.asp which has the following, which was typed out using notepad

Code:

<%
dim drv, dbq, cs, oC, oRS, oCM
drv = "Provider=Microsoft.Jet.OLEDB.4.0;"
dbq = "Data Source=C:\WINDOWS\Desktop\html\htmldatabase.mdb"
cs = drv & dbq
set oC = server.createobject("ADODB.connection")
set oRS = server.createobject("ADODB.recordset")
set oCM = server.createobject("ADODB.Command")
%>

the code that is pasted above(that i posted the first time) has the file extension .asp on it. )its named "addrecord.asp"

the website, or html document im using to get the information from is the database.htm and its code is as follows:

Code:

<html>
<head>
<link rel="stylesheet" type="text/css" href="styles.css">
<!--setting page background color and text color-->
</head>
<body>
<FORM ACTION="addrecord.asp" method="post">
<font color = white">
Phone<input type="text" name="Phone" size="7">
<p>
First Name <input type="text" name="FirstName" size="15">
<p>
Last Name <input type="text" name="LastName" size="15">
<p>
Address <input type="text" name="Address" size="20">
<p>
City <input type="text" name="city" size="15">
<p>
Province <input type="text" name="province" size="15">
<p>
Postal Code <input type="text" name="PostalCode" size="7">
<input type="submit" value="add">
<input type="reset" value="reset">
</font>
</FORM>
</body>
</html>

I do not get any errors, the only thing is that the information i input from the database page, will not write to the database i created.

**russell** · 11-12-2004 04:22 PM

ok, your code with a couple of debugging statements:

Code:

<link rel="stylesheet" type="text/css" href="styles.css"/>
<!-- #include file = "Include.asp" -->
<!-- #include file = "Adovbs.inc" -->
<html>
<HEAD>
<title>
</title>
</HEAD>
<body>
<FORM ACTION="database.htm">
<INPUT TYPE = SUBMIT VALUE="Return to Database Page">
</FORM>
<%
Phone=request.form("Phone")
FirstName=request.form("FirstName")
LastName=request.form("LastName")
Address=request.form("Address")
city=request.form("city")
province=request.form("province")
PostalCode=request.form("PostalCode")

For each f in Request.Form
   Response.Write f & " " & Request.Form(f) & "<br>"
Next

%>

<%
strQuery = "Insert into Contacts (Phone, FirstName, LastName, Address, City, province, PostalCode) values ('"& Phone &"', '"& FirstName &"', '"& LastName &"','"& Address &"','"& city &"', '"& province &"', '"& PostalCode &"')"

oC.open cs
oCM.ActiveConnection = oC
oCM.CommandText = strQuery
oCM.CommandType = adCmdText
oCM.Execute
'response.write(strQuery)

Response.Write strQuery

oC.close
set oC=nothing
%>
<p> The Current Records are in the Database:</p>
<br>
<% oRS.open "Select * from Contacts", cs %>

<table border = "0" width="100%">
<tr><td>Phone</td>
    <td>First Name</td>
    <td>Last Name</td>
    <td>Address</td>
    <td>City</td>
    <td>Province</td>
    <td>Postal</td>
<tr>
<% do while not oRS.EOF %>
<tr>
	<td><% = oRS("Phone") %></td>
	<td><% = oRS("FirstName") %></td>
	<td><% = oRS("LastName") %></td>
	<td><% = oRS("Address") %></td>
	<td><% = oRS("City") %></td>
	<td><% = oRS("province") %></td>
	<td><% = oRS("PostalCode") %></td>
</tr>
<% oRS.movenext
loop

oRS.close
set oRS = nothing
%>
</table>

</body>
</html>

What do you get when you run it now?

**Ennis** · 11-12-2004 06:14 PM

Originally posted by russell
ok, your code with a couple of debugging statements:

Code:

<link rel="stylesheet" type="text/css" href="styles.css"/>   <html> <HEAD> <title> </title> </HEAD> <body> <FORM ACTION="database.htm"> <INPUT TYPE = SUBMIT VALUE="Return to Database Page"> </FORM> <% Phone=request.form("Phone") FirstName=request.form("FirstName") LastName=request.form("LastName") Address=request.form("Address") city=request.form("city") province=request.form("province") PostalCode=request.form("PostalCode") For each f in Request.Form Response.Write f & " " & Request.Form(f) & "<br>" Next %> <% strQuery = "Insert into Contacts (Phone, FirstName, LastName, Address, City, province, PostalCode) values ('"& Phone &"', '"& FirstName &"', '"& LastName &"','"& Address &"','"& city &"', '"& province &"', '"& PostalCode &"')" oC.open cs oCM.ActiveConnection = oC oCM.CommandText = strQuery oCM.CommandType = adCmdText oCM.Execute 'response.write(strQuery) Response.Write strQuery oC.close set oC=nothing %> <p> The Current Records are in the Database:</p> <br> <% oRS.open "Select * from Contacts", cs %> <table border = "0" width="100%"> <tr><td>Phone</td> <td>First Name</td> <td>Last Name</td> <td>Address</td> <td>City</td> <td>Province</td> <td>Postal</td> <tr> <% do while not oRS.EOF %> <tr> <td><% = oRS("Phone") %></td> <td><% = oRS("FirstName") %></td> <td><% = oRS("LastName") %></td> <td><% = oRS("Address") %></td> <td><% = oRS("City") %></td> <td><% = oRS("province") %></td> <td><% = oRS("PostalCode") %></td> </tr> <% oRS.movenext loop oRS.close set oRS = nothing %> </table> </body> </html>

What do you get when you run it now?

i don't understand that for loop....

and i will let you onow what i get when i try this later.
appreciate your help tho. thanks.

**buntine** · 11-12-2004 07:28 PM

It will juest print out a list of the name/value pairs in the Form collection.

**Ennis** · 11-12-2004 08:23 PM

edit: i just add whats in red to my code, correct?

i added this to my asp page. and it still won't write to the database...or come up in the table at the bottom.

Thread: The information from the form on my website won't add to my database.

Thread Tools

Display

The information from the form on my website won't add to my database.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions