Solved

Senting Form output to sql 2000 database

Posted on 2004-08-02
3
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 29

Expert Comment

by:coreybryant
ID: 11696394
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
ID: 11697375
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
ID: 11698747
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

615 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