sander69
asked on
Senting Form output to sql 2000 database
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!
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!
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
-Corey