
February 12th, 2004, 09:43 AM
|
|
Registered User
|
|
Join Date: Jan 2004
Location: england
Posts: 18
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
updating a record
hi,
I have a database into which i insert my entries.What I need to know is how can i update them?I need to view the selected entry in a form where i can just cancel the text and write over it and then press the update button.my connection method is as follows and this is an extract from my cancel page:
sql="select * from users where city like '%"&city&"%' AND cat like '%"&cat&"%'"
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=e:*.mdb"
Set RS=OBJdbConnection.Execute(sql)%> <%Do while NOT RS.EOF%
<form method=post action="canc.asp?c=<%=RS("id")%>
">
<input type="hidden" name="data2" value="<%=dte%>">
<input type="submit" name="Cancella2" value="Cancella">
</form>
|