— Learning is not just about technology, but also about dreams!
Home HTML JAVASCRIPT CSS VUE REACT PYTHON3 JAVA C C++ C# AI GO SQL LINUX VS CODE BOOTSTRAP GIT Local Bookmarks
ADO Tutorial
ADO Tutorial
ADO Introduction
ADO Database Connection
ADO ADO Recordset
ADO Display
ADO Query
ADO Sorting
ADO Add Records
ADO Update Records
ADO Delete Records
ADO Speed Up Scripts
ADO Command Object
ADO Connection Object
ADO Error Object
ADO Field Object
ADO Parameter Object
ADO Property Object
ADO Record Object
ADO Recordset Object
ADO Stream Object
ADO Data Types
ADO Summary
ADO Examples
ADO Update Records
ADO Speed Up Scripts Using GetString()
In-Depth Exploration
AI Tools, Chatbots, and Virtual Assistants
Web Applications and Online Tools
Computer
Web Services
Scripts
Web Service
Computer Science
Development Tools
Programming Languages
ADO Delete Records
We can use SQL's DELETE command to delete a record from a database table.
Delete Records from a Table
We want to delete a record from the Customers table in the Northwind database. First, we need to create a table listing all records in Customers.
List Database
<%
for each x in rs.Fields
response.write("| " & ucase(x.name) & " | ")
next
%>
|
<input type="submit" name="customerID" value="">
|
|
If the user clicks the button in the "customerID" column, a new file named "demo_delete.asp" will open. This file contains source code that creates input fields based on the fields of the record in the database, along with a "Delete" button to delete the current record:
Delete Record
<%
else
sql="DELETE FROM customers"
sql=sql & " WHERE customerID='" & cid & "'"
on error resume next
conn.Execute sql
if err0 then
response.write("No update permissions!")
else
response.write("Record " & cid & " was deleted!")
end if
end if
conn.close
%>
ADO Update Records
ADO Speed Up Scripts Using GetString()
Byte Ark Coding Plan
Supports mainstream large models including Doubao, GLM, DeepSeek, Kimi, MiniMax, etc., officially supplied for stable and reliable service.
¥9.9
/ month
Sign Up Now
iFLYTEK Xingchen Coding Plan
Includes free model invocation quotas; supports DeepSeek, GLM, Kimi, MiniMax — an all-in-one experience and deployment platform.
¥3.9
/ month
Sign Up Now
Click to Share Notes
Category Navigation
Python / Data Science
AI / Intelligent Development
Frontend Development
Backend Development
Databases
Mobile Development
DevOps / Engineering
Programming Languages
Computer Fundamentals
XML / Web Service
.NET
Website Development
Advertisement
ADO Tutorial
ADO Tutorial
ADO Introduction
ADO Database Connection
ADO ADO Recordset
ADO Display
ADO Query
ADO Sorting
ADO Add Records
ADO Update Records
ADO Delete Records
ADO Speed Up Scripts
ADO Command Object
ADO Connection Object
ADO Error Object
ADO Field Object
ADO Parameter Object
ADO Property Object
ADO Record Object
ADO Recordset Object
ADO Stream Object
ADO Data Types
ADO Summary
ADO Examples
Online Examples
·HTML Examples
·CSS Examples
·JavaScript Examples
·Ajax Examples
·jQuery Examples
·XML Examples
·Java Examples
Character Sets & Tools
· HTML Character Set Settings
· HTML ASCII Character Set
· JS Obfuscation/Encryption
· PNG/JPEG Image Compression
· HTML Color Picker
· JSON Formatter Tool
· Random Number Generator
Latest Updates
· GraphRAG Beginner Tutorial
· Dart Enumerations and Symbols
· Dart Unit Testing
· Dart Concurrency and Iso...
· Dart Stream
· Dart Asynchronous Programming
· Dart Package and Library Management
Site Information
· Feedback
· Disclaimer
· About Us
· Article Archive
Follow WeChat
My Favorites
Bookmark Articles
Browsing History
Clear All
No records yet
YouTip