ASP form insert to Access database

by: carrzkissPosted on 2009-11-08 at 16:31:36ID: 25772738

There is nothing wrong with the code itself that I can see.
Everything looks fine.
(HTML a little bad, needs to be in a table or DIV to really stand out)
But other than that, it is fine.

Your Form Names where incorrect.
Run this code and you should be ok.

Carrzkiss

<%
' To insert an item we do this
if request.Form("preregister")="Insert" then
Set InsCom=Server.CreateObject("ADODB.Command")
InsCom.ActiveConnection=objConn
InsT= Trim(request.Form("Title"))
InsF = Trim(request.Form("Firstname"))
InsS = Trim(request.Form("Lastname"))
InsD = Trim(request.Form("Degree"))
InsSP = Trim(request.Form("Specialty"))
 
InsCom.CommandText = "Insert into Doctors(Title, Firstname, Lastname, Degree, Specialty)Values(?,?,?,?,?)"
InsCom.Parameters.Append InsCom.CreateParameter("@Title", adChar, adParamInput, 255, InsT)
InsCom.Parameters.Append InsCom.CreateParameter("@Firstname", adChar, adParamInput, 255, InsF)
InsCom.Parameters.Append InsCom.CreateParameter("@Lastname", adChar, adParamInput, 255, InsS)
InsCom.Parameters.Append InsCom.CreateParameter("@Degree", adChar, adParamInput, 255, InsD)
InsCom.Parameters.Append InsCom.CreateParameter("@Specialty", adChar, adParamInput, 255, InsSP)
 
 
InsCom.Execute
response.Write"Record Inserted Successfully!<br /><a href=""preregister.asp"" />Go Back to main page</a>"
end if
%>
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Pre-Registration</title>
</head>
 
<body>
<p><font face="Calibri">&nbsp;<font size="5">Program 
Pre-Registration </font></font>
<font size="5" face="Calibri"><br>
</font>
<br />
&nbsp;</p>
<form action="preregister.asp" method="post">
<input type="hidden" name="preregister" value="Insert" />
<font face="Calibri">&nbsp;</font><font face="Calibri" color="#FFFF00" size="4">Personal 
Information</font><p><font face="Calibri">Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="Title">
<option selected>Dr.</option>
<option>Mr.</option>
<option>Mrs.</option>
</select></font></p>
<p><font face="Calibri">First Name&nbsp;
<input name="FirstName" type="text" size="23" /></font></p>
<p><font face="Calibri">Last Name&nbsp;
<input name="LastName" type="text" size="34" /></font></p>
<p><font face="Calibri">Degree&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="Degree">
<option selected>O.D.</option>
<option>M.D.</option>
<option>B.A.</option>
<option>M.A.</option>
<option>A.D.</option>
</select></font></p>
<p><font face="Calibri">Specialty&nbsp;&nbsp;&nbsp;&nbsp;
<select size="1" name="Specialty" multiple>
<option>Optometrist</option>
<option>Opthamologist</option>
<option>Optician</option>
</select></font></p>
<p>&nbsp;</p>
<input type="submit" name="Submit" value="Pre-Register" /> </p>
</form>
<br />
 
</body>
</html>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:

Select all Open in new window

by: tmurray22Posted on 2009-11-08 at 21:12:26ID: 25773523

The form now appears thanks. The data doesnt write to DB though. Upon post an error "page cannot be displayed appears.

by: chris18Posted on 2009-11-08 at 22:04:57ID: 25773661

does the access database .mdb file has write permissions ?

by: tmurray22Posted on 2009-11-08 at 23:47:08ID: 25774020

I got this working but have another issue will make new post though.

by: chris18Posted on 2009-11-08 at 23:49:53ID: 25774029

If you can share it with us how you got the solution it will benefit everyone.

by: carrzkissPosted on 2009-11-09 at 01:23:49ID: 25774438

chris18
If you would have read my post you would have seen the following:

>> Your Form Names where incorrect.

The FirstName & LastName was incorrectly written.
Changing that fixed the issue.

There was nothing wrong with the permissions of the database.
As he wrote: Inserted Blank Fields.
Which means that it is writting to the database, but not writting records.

That is it.
Enjoy
Carrzkiss

by: chris18Posted on 2009-11-09 at 01:55:02ID: 25774561

Carrzkiss

"The form now appears thanks. The data doesnt write to DB though"

It was this comment that prompted me to think of the db permission issue.

Chris

by: carrzkissPosted on 2009-11-09 at 02:18:01ID: 25774648

===============================
The form now appears thanks. The data doesnt write to DB though. Upon post an error "page cannot be displayed appears.
===============================

The page was incorrectly named (or) the form was incorrectly directed

<form action="preregister.asp" method="post">

The page was named: Insertform.asp

--------------------
That is the reason why it would not write to the database.
The page needed to send to itself, NOT to another page.
So when the page was incorrectly named, and the form submitted
The error would accure.
Renaming either the page or the form action="page.asp" resolved the issue.

Hope that clears it up.
Have a good one Chris.

Carrzkiss

by: chris18Posted on 2009-11-09 at 03:38:05ID: 25774954

Carrzkiss

Yes it cleared it up.

I was just posting the reason for my comment since tmurray22 has posted the comment

"The form now appears thanks. The data doesnt write to DB though"

AFTER your proposed solution.

Thanks for clearing it up

Chris

by: carrzkissPosted on 2009-11-09 at 03:52:13ID: 25775025

not a problem
I was unaware that it was an issue with "tmurray22", if I would have none that I would have corrected it myself when I posted the code back here.

Have a good one Chris.
Carrzkiss

Question

ASP form insert to Access database

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Active Server Pages (ASP)

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press