Update/Insert on MSSQL Table using ASP forms

[stathis]

Hello everyone!

I have a problem that it's bothering me for some time now and i will need a lot of help from you. I don't know how easy or difficult it is to be done but i would appreciate any help.

I have an mssql 2000 db with table "table1". Attributes for "table1" are:

ID (Primary Key)
field1
field2
field3
field4
field5
field6
field7

I'm trying through DreamWeaver MX to create a form through ASP and Text Fields, so that i can update "table1" through the form and also on another page to show the results of my table.

I have created a form which will be accepting 25 rows, each row having field1, field2, .., field7.

I cannot seem to get it to update "table1".

Any ideas how this can be done?

Regards
Stathis

[putts]

<form action="do.asp" method="post">
<input type="text" name="myVal">

<input type="submit">
</form>


do.asp

<%
set db = server.createObject("ADODB.Connection")
db.open "connection string"

db.execute("UPDATE table SET field1='" & request("myVal") & "' WHERE ID=1")
%>


very basic, but hopefully gets you going.