amend asp

Amend ASP Code

<%
Dim Category
Dim Description
Dim cn
Category = request.form("txtCategory")
Description = request.form("txtDescription")
catID = request.form("txtID")
strSQL="UPDATE Categories 
SET CategoryName='" & Category & "'",Description='" & Description & "'"
strSQL = strSQL & " WHERE CategoryID =" & CatID
set cn = Server.CreateObject("ADODB.Connection")
cn.Open "NorthWindDSN"
cn.Execute(strSQL)
Response.write "You have successfully amended a record."
cn.Close
Set cn = nothing
%>

Click Next for delete.asp

1. Installing the Personal Web Server (PWS)
2. or Internet Information Services (IIS)
3. Create the Example ASP Files
4. Create a DSN Connection
5. Connect to the Database
6. Modify Access Data Online
7. Inserting Data
8. Modifying Data
9. Deleting Data
10. Data Insert Form

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger×