hi,
pls help as i'm new in asp. i'm developing the administrative part of a website for my project. i'm having trouble with the "updating data" part. for example, i have done the 'add staff' and "delete staff' part with no problem. but how do i modify or update the data that i have previously added from the webpage. below are my codings. i have separated it into two asp files, the frmmodify.asp & frmmodifyprocess.asp. pls help.
frmmodify.asp
<html>
<head>
<title>modify customer</title>
</head>
<body>
<%
Set myconn=server.createobject("ADODB.Connection")
dbpath="C:\Inetpub\wwwroot\final\greatscape.mdb"
myconn.open "Provider=Microsoft.Jet.Oledb.4.0;Data source=" &dbpath
name=request("name")
address=request("address")
phone=request("phone")
Email=request("email")
hphone=request("hphone")
postcode=request("postcode")
city=request("city")
cusid=request("cus_id")
set rs= Server.CreateObject("ADODB.Recordset")
sql="Select * from Customers where cus_id=" &cusid
rs.Open sql,myconn,1,2
rs.update
rs("name")=name
rs("address")=address
rs("phone")=phone
rs("email")= Email
rs("hphone")=hphone
rs("postcode")=postcode
rs("city")=city
rs.update
%>
<form action="frmModify.asp" method="post">
Name <input type=text name="name" value="<%=rs("name")%>">
<br>
Address <input type=text name="address" value="<%=rs("address")%>">
<br>
Phone <input type=text name="phone" value="<%=rs("phone")%>">
<br>
Email <input type=text name="email" value="<%=rs("email")%>">
<br>
Postcode <input type=text name="postcode" value="<%=rs("postcode")%>">
<br>
City <input type=text name="city" value="<%=rs("city")%>">
<br>
Hphone <input type=text name="hphone" value="<%=rs("hphone")%>">
<br>
<input type=submit value="Modify">
</form>
<%
myconn.close
set rs=nothing
%>
<a href="viewcustomer.asp">View Record Updated</a>
</body>
</body></html>
frmmodifyprocess.asp
<%
dim myID
Set myconn=server.createobject("ADODB.Connection")
dbpath="C:\Inetpub\wwwroot\final\greatscape.mdb"
myconn.open "Provider=Microsoft.Jet.Oledb.4.0;Data source=" &dbpath
myID=Request.Form("cus_id")
sql= "UPDATE Customers SET name='" &_
Request.Form("name") &_
"', address= '" & Request.Form("address")&_
"', phone= '" & Request.Form("phone")&_
"', state='" & Request.Form("state") &_
"', hphone='" & Request.Form("hphone") &_
"', postcode='" & Request.Form("postcode")&_
"', city='" & Request.Form("city")&_
"', WHERE cus_id= " &myID
myconn.execute(sql)
myconn.close
set myconn=nothing
%>
<a href="viewcustomer.asp">View Record Updated</a>
<html>
<head>
<title>modify customer</title>
</head>
<body>
<BODY background="images/nabkgnd.jpg">
<center>
<H2>modify customer</H2></CENTER>
<form id="Update" action="frmModifyProcess.asp" method="POST" >
<DIV align=center>
<TABLE cellSpacing=0 cellP