ASP.NET Forum

**dani01** · 09:59 PM

Hi,
I created a asp page using a frontpage. i made a form and set that the information submitted is sent to mdb databse. But when publish the page and fill in to test the page by filling it the databse never gets the info and the same page appears after i hit the submit button????

**higginbt** · 05-04-2006, 07:38 AM

I'm not really sure what your saying, would need to see some code.

as we'd need to see how your inserting the data from the form into the database.
You cant just tell a form to submit to the database there is a bit more to it than that.

**ADAM Web Design** · 05-04-2006, 12:19 PM

Using FrontPage is not the best solution for ASP either. It creates some bulky, buggy code that won't help you in any way.

Like higginbt says, we need the code to figure it out, though.

**dani01** · 05-04-2006, 04:46 PM

I actually created a form with Frontpage and inserted form and every thing in to it and set it like that the data submitted is sent to a .mdb databse that frontpage created in the web folders during that process............But when the submit button is hit the same page reappears?>????????

**chrishirst** · 05-04-2006, 05:13 PM

is it set to go somewhere else ?

**dani01** · 05-04-2006, 07:37 PM

Yes it is set to go anywhere on host server or on pc???

**ADAM Web Design** · 05-04-2006, 11:37 PM

dani01, I'll rephrase this:

Without the code, anything you're asking isn't going to get answered.

So...please provide us with the code.

Thanks.

**higginbt** · 05-05-2006, 06:31 AM

What chrishirst meant.

Where have you told the form to go after you press the submit button

<form name="form1" method="post" action="linkpage.asp">

Like in the example above when the submit button is pressed it will try and load up the linkpage.asp.

Since english does not seem to be your first language you will get much better help if you copy and paste the code from your page on here.

**dani01** · 05-05-2006, 08:39 AM

Well!! thats the whole code!!

<%@ Language=JavaScript %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<meta name="VI60_defaultClientScript" content="VBScript">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Name</title>
</head>
<body bgcolor="#000000" text="#FFFF00">
<form method="POST">
<p align="center"><font face="Verdana" size="1" color="#FFFF00"><b>Name:</b></font>
<input type="text" name="T1" size="24"></p>
<p align="center"><b><font face="Verdana" size="1">E-mail: </font></b><input type="text" name="T2" size="25"></p>
<p align="center"><b><font face="Verdana" size="1">City:</font></b> <input type="text" name="T3" size="20"></p>
<p align="center"><b><font face="Verdana" size="1">Country:</font></b> <input type="text" name="T4" size="20"></p>
<p align="center"><b><font face="Verdana" size="1">Log In ID: </font></b><input type="text" name="T5" size="20"></p>
<p align="center"><b><font size="1" face="Verdana">Password: </font></b><input type="text" name="T6" size="20"></p>
<p align="center"><font face="Verdana" size="1"><b>Confirm Password: </b></font><input type="text" name="T7" size="20"></p>
<p> </p>
<p align="center"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
</body>
</html>

**higginbt** · 10:09 AM

Well for a start this form doesnt do anything apart from hold
email
city
country
log in id
password and confirm password
with two buttons at the bottom submit and a reset

When you click submit you havent told you form to do anything.

you need to tell it to do something. like go to a page that has your asp code on it

which you can do in the way i stated before.

You've not really created an ASP page. Its just HTML saved with a.asp extensioni is my guess

**higginbt** · 05-05-2006, 10:11 AM

The page you send it to will have to:

1.create a connection to the database

2. Retrieve the infomation back from the form

3.Insert the information in to the database.

all you have done is create a form

**Midano** · 04:24 PM

Quote:

Originally Posted by dani01

Hi,
I created a asp page using a frontpage

Here's your problem right there. You won't have even basic understanding of ASP by using FrontPage.
Start over, use text editor, look at the code.

**ADAM Web Design** · 05-05-2006, 08:19 PM

Midano, in a twisted way, is right.

ASP + FrontPage = disaster.

If you're going to learn ASP, and I mean really learn it and learn how it works, you gotta get under the hood and get your hands dirty. And in doing so, you'll have to learn how to hand-code it.

If you want some good resources to get you started, here are some:

www.haneng.com (still a good resource after the 6 years I've known about it)
www.4guysfromrolla.com (this site just OWNS for droppin' mad ASP knowledge on young bruthas.)
www.asp101.com (rookie, but still cool.)

Anyway, your problem is that your form doesn't have an action attribute set for it. What page is it supposed to go to? It doesn't say. So, you've got a dead form.

**dani01** · 05-06-2006, 12:37 AM

Thnx alot guys!!

**dani01** · 05-06-2006, 12:38 AM

ok
tell me any best software to create a asp page!!!!!
other then frontpage??

**ADAM Web Design** · 05-06-2006, 12:48 AM

A text editor, such as Notepad or Notepad ++.

**higginbt** · 05-09-2006, 05:36 AM

If you must you a wysiwyg editor then i would suggest dreamweaver. It's what i use, but i have the bonus of knowing how to create html and ASP pages by hand in an editor.

In fact i always hand code asp in dreamweaver.

Its not as bas as front page but it still adds unwanted extra code. If you learn html its easy to sort it out.

**MyOpinion** · 05-10-2006, 04:01 PM

Hi Dan,

One problem that I have identified is that you need to sepcify the action attribute in your <form> tag. You need to tell the server which page should be call when you submit the form.

e.g. <form name="form1" method="post" action="linkpage.asp">

Good luck