Delete a record from your
This is an article on using
Complete tutorial on editing
This article wraps up the
database quickly and easily
Recordset. It uses GetRows
and updating records in the
details of the real time
without having to use a
method to speedup database
database. Each and every
data grid that started in
recordset. Deleting a record
access. One of the fastest
step explained in detail for
part one of this two-part
from a database table is a
ways of displaying database
ASP beginners. Both
article. It looks at the
simple task. Answer four
records with ASP. Sample
Connection and Recordset
JavaScript code that
questions below and click
Database and Code available
Objects discussed.
contacts our database server
submit. The sql statement
for download.
and allows us to update data
will be generated for you.
in a database without
actually refreshing the page.
Date: Apr, 15 2002 Date: Aug, 27 2000 Date: Mar, 27 2000 Date: Feb, 14 2002 |
This is a brief and very
This is the first of the
Many times people will make
How do I get the Unique ID or
useful tutorial on creating
four-part "Advanced SQL
the mistake of naming a
Auto ID of the record I just
and using stored procedures
Techniques" series,
database field with an SQL
entered? The solution is
with your asp applications.
which describes a quick and
Reserved word. This is an
really quite simple.
A stored procedure is
efficient way to delete
easy mistake to make. It's
nothing more than an sql
duplicate records from a
hard to remember every
statement stored inside a
table.
single one. Here's a concise
database. The database can
listing of SQL Reserved
be SQL Server or MS Access
words to help you along.
as well as others. A stored
procedure is compiled by
your database (for the most
part) one time, when it is
entered. This results in
faster database executions
and overall performance
updates, and it further
separates the sql statement
from your asp leaving you
with more readable code.
This tutorial describes:
What is a stored procedure?,
Writing stored procedures,
Getting the stored procedure
into the database, Calling
stored procedures in ASP
pages, and Modifying and
removing stored procedures.
Date: Aug, 13 2000 Date: Oct, 25 2001 Date: Jun, 17 2002 Date: Dec, 10 2002 |