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<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.
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<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.