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

Querying the Database

In the last chapter, we inserted information into the database. In this chapter, we're going to pull it out again. To do this, the ActiveX Data Objects (ADO) includes a special kind of object for us to use. It's called a recordset, and it's just that: a set of records from the database. We're going to use a recordset to check the username and password a user submits when logging into the site.

First let's create the form they're going to use. Make a copy of template.asp called login.asp and save it in the Web server home directory. All we really need from the user at this point is their username and password. If they're really who they say they are and they've registered, we'll have all their other information already. ...

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