Active Server Pages 3.0 from Scratch

More on RecordSets

There are actually several kinds of recordsets. Some are read-only, meaning we can't change the data within them. Some allow us to scroll up and down among the data; some don't. We can control all of those attributes of a recordset when we create it directly using a CreateObject statement instead of letting ASP do it for us, as we have been doing.

Let's look at the issues we need to take into consideration, and then we'll look at syntax. When we create a recordset using

set mySet = Server.CreateObject("ADODB.RecordSet")

we need to set several attributes about it. These attributes will be discussed in the following sections.

Source

The first attribute is the source of the data—where is it coming from? So far we've been using ...