Form Data Not added to Database

K

KMD

I am using FrontPage 2003, Windows 2000Server, I created a simple form with 4
fields. I can input the data and click submit and get a confirmation page,
but the data does not get into the access database. We had Frontpage create
the database connection automatically, which was successful.
 
T

Thomas A. Rowe

Make sure the web site in IIS MMC under it properties dialog, Home directory has the Application
Root set.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
K

KMD

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<p>FIRST NAME</p>
<p><input type="text" name="FirstName" size="20"></p>
<p>LAST NAME</p>
<p><input type="text" name="LastName" size="20"></p>
<p>STUDENT ID</p>
<p><input type="text" name="StudentID" size="20"></p>
<p>COURSE</p>
<p><input type="text" name="Course" size="20"></p>
<p>EMAIL</p>
<p><input type="text" name="Email" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset"
value="Reset" name="B2"></p>
</form>

</body>

</html>
 
K

KMD

Do you need to set an OBDC connection on the server and point to the
database? I have a virtual directory setup within my main web site, with
this in mind, where do i need to check the application root set?

Thanks,
 
K

KMD

I have clicked on the virtual dir>properties>Home Dir>and the app name is my
database name. Do you need to have the path or just the name there? Also my
database is located in the main web in the folder fpdb with the customer.dbf
database and a results table within the database.
In summary:
-My form is setup
-I receive a confirmation page
-The form is in a Virtual Dir
-The database is located in the folder fpdb named customer (no extensions or
path)
-Scripts and Executables and Low (IIS Process)
-I made sure there was no obdc mdriver specified in the control panel, Do i
need this, i tried it both ways and it did not make a difference.
Anything else it could be or I am missing

-The application name specified in the virutal Dir>Application is customer
 
T

Thomas A. Rowe

Yes, you must have a database connection setup on the server. FP extensions do not work with virtual
directories, if you want to store the database outside of the web root, then use a System DSN
database connection.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
S

Stefan B Rusynko

That's not using a database connection (see thread below)
You have a send to file (form_results.csv) in a disc based path that probably does not exist
(fpweb:///_private)
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->




| <html>
|
| <head>
| <meta http-equiv="Content-Language" content="en-us">
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <title>New Page 1</title>
| </head>
|
| <body>
|
| <form method="POST" action="--WEBBOT-SELF--">
| <!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv"
| S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
| <p>FIRST NAME</p>
| <p><input type="text" name="FirstName" size="20"></p>
| <p>LAST NAME</p>
| <p><input type="text" name="LastName" size="20"></p>
| <p>STUDENT ID</p>
| <p><input type="text" name="StudentID" size="20"></p>
| <p>COURSE</p>
| <p><input type="text" name="Course" size="20"></p>
| <p>EMAIL</p>
| <p><input type="text" name="Email" size="20"></p>
| <p><input type="submit" value="Submit" name="B1"><input type="reset"
| value="Reset" name="B2"></p>
| </form>
|
| </body>
|
| </html>
|
|
| "John Cello" wrote:
|
| > Can you post a sample of your page code for us to look at?
| >
| > John Cello
| > John Cello Consulting
| > Communications for Business
| > www.johncelloconsulting.com
| >
| >
| > "KMD" wrote:
| >
| > > I am using FrontPage 2003, Windows 2000Server, I created a simple form with 4
| > > fields. I can input the data and click submit and get a confirmation page,
| > > but the data does not get into the access database. We had Frontpage create
| > > the database connection automatically, which was successful.
 
Top