|
Connections, Commands and
You all must have seen and
This little wizard will help
This article wraps up the
Procedures is a sample
done stuff with the
you count records and
details of the real time
chapter from Professional
RecordSet object, infact
display the total. Simply
data grid that started in
Active Server Pages which
everything is done with the
fill in the form, and it
part one of this two-part
discuss in depth all the
RecordSet object. Now, this
will generate the code for
article. It looks at the
issues related with
acticle explains how to use
you.
JavaScript code that
establishing connection to a
GetRows to page through the
contacts our database server
database to the carrying out
records that you recieve
and allows us to update data
of commands and procedures.
from the SELECT. It's much
in a database without
faster than MoveNext,
actually refreshing the page.
because it closes the
database connection
immediately whereas MoveNext
loops through the records
with the overhead of the
database connection. Plus
GetRows let's you count the
records correctly!
Date: Mar, 20 2000 Date: Oct, 04 2003 Date: Apr, 15 2002 Date: Feb, 14 2002 |
|
MySQL is the most popular
This is the first of the
This article describes
This article shows how to
open source database system
four-part "Advanced SQL
several ways to use a SQL
publish and distribute
available today, and is
Techniques" series,
calculated field and the
Microsoft Access reports on
currently installed on over
which describes a quick and
ORDER BY clause to arrange a
the web using ASP.
two million servers
efficient way to delete
recordset in random order.
worldwide. This article
duplicate records from a
It provides a simple tool
takes a look at using the
table.
for verifying that the
free MyODBC driver to talk
results are uniformly
to a MySQL database from an
random. Also shows a
ASP script.
technique for bubbling
records with certain
attributes to the top of an
otherwise randomized list.
Date: Jan, 17 2002 Date: Oct, 25 2001 Date: Sep, 13 2001 Date: Apr, 10 2001 |