Solved

Senting Form output to sql 2000 database

Posted on 2004-08-02
3
193 Views
Last Modified: 2013-12-24
To say that I do not know what I am doing would be such a gross understatement of the truth it pains me.

I am trying to use Frontpage 2003 to create a form that will capture survey results and then send those servey results to a SQL server 2000 table I created.

I have made the form and saved it as an asp.  I have created the table.  I have mapped all of the input variables to the table variables.  I can access the table from IE.  I can enter results into the table.  

BUT when I hit the submit button the form resets and nothing gets sent to the table.

I am pretty sure the extensions are installed on the server be cause I can access the asp from IE.

I am lost and under the gun.  Someone ... Anyone ... please help!
0
Comment
Question by:sander69
3 Comments
 
LVL 29

Expert Comment

by:coreybryant
Comment Utility
I am not too sure, but you might need to use a DSN connection for MSSQL?  Or are you doing all this on one machine?

-Corey
0
 
LVL 12

Expert Comment

by:rcmb
Comment Utility
My recommendations are to create your form as you have done and then create a separate asp file containing this sql statement.

You will need to create an ODBC connection to your SQL database and then make the connection from FrontPage.

In you second file you can use the database connection wizard to connect to your database after you have create the ODBC connection and added the database to FrontPage.

In step 2 of the DBRW create a custom query and do something like

INSERT INTO Table (Value1, Value2, ...) VALUES ('::FormValue1::', '::FormValue2::', ...)

The redirect your page back to some other view like the page before the form. This gives you much more control over your design.

If you need more data let me know.

RCMB
0
 
LVL 3

Accepted Solution

by:
wcameron earned 500 total points
Comment Utility
OK, step 1. Insert some dummy data into the database and see if you can use the DRW to view the data. That will confirm that your database connection is working fine.

Step 2. create a form with only one field from the table and see if you can create a new record with the single form field such as FirstName. This will tell you that the basic process of sending a form to a database does work.

In Internet Explorer, go to Tools-Options and in the advanced tab turn off Friendly HTML messages. This will tell IE to display more detailed error messages (including what line of code is choking the page) that will allow you to debug it more easily.

the most difficult part is determining where the problem lies and this step-by-step approach will help you to track it down
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now