Low cost ecommerce web development India flash website design
Deleting Records
Use the SQL DELETE statement to delete one or more records satisfying a
particular criterion.
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<body> <p><a href="http://www.vishwatech.com" title="Low cost ecommerce web development India
flash website design">Low cost ecommerce web development India
flash website design</a>
<%
Dim DB
Set DB = Server.CreateObject (“ADODB.Connection”)
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
“C:\Databases\Students.mdb”)
DB.Execute (“DELETE * FROM Students WHERE FirstName =
‘Manas'”)
%>
</BODY>
</HTML>
Exercise the utmost caution while using the DELETE statement for two
reasons:
40
§ Firstly, because there's no Undo available to restore your changes! Once
it's gone, it's gone.
§ And secondly, because if you forget the WHERE clause, it proceeds to
delete all of the records in the table.
There – we're done!
More ...
To gain an in-depth understanding of accessing data and complex queries,
please refer to the SQL reference and
are pretty exhaustive guides that you can refer to anytime for looking up a
particular item easily.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73