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. ...
Get Active Server Pages 3.0 from Scratch now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
