O'Reilly logo

Active Server Pages 3.0 from Scratch by Nicholas Chase

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required