Amend Select ASP Code
<html>
<head>
<title>Select category to change</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Please select which category you wish to modify.<hr></p>
<%
Dim rst
Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open "Categories", "DSN=NorthWindDSN"
%>
<form name="frmFind" method="get" action="amend_change.asp">
<select name = "ProdCats" Size = "1">
<%
DO WHILE NOT rst.EOF
Response.Write "<option value= '" & rst("CategoryID") & "'>"
Response.Write rst("CategoryName") & "</option>"
rst.MoveNext
Loop
rst.close
set rst=Nothing
%>
</select>
<input type="submit">
</form>
</body>
</html>Click Next for amend-change.asp
- Installing the Personal Web Server (PWS)
- or Internet Information Services (IIS)
- Create the Example ASP Files
- Create a DSN Connection
- Connect to the Database
- Modify Access Data Online
- Inserting Data
- Modifying Data
- Deleting Data
- Data Insert Form
No comments:
Post a Comment
Comments subject to moderation before publishing.