While the book.asp page looks nice, there's really nothing new here for you to learn. The page we really need to look at is update.asp, which you can't even see through your browser, since it has no HTML. Rather, it's comprised of VBScript. The script does some processing and then sends the user to another page with the Response.Redirect command. Go ahead and open it up in your text editor or take a look at the code here.
You can see the UPDATE and INSERT statement that we talked about in Lesson 2. All the information we had gathered from previous pages was passed to the querystring for this page. Then the SQL statements were built from the values pulled from the querystring.
As you might guess, the code ourdate=FormatDateTime(now,vbLongDateTime) loads the current date into the variable ourdate. We're loading this into the database, so we know exactly when the appointment was made. If the person doesn't confirm, I can go into the database later and change the appointment status to Open and remove the email address that was inserted into the Appointments table.
Finally, Response.redirect(URL) tells the ASP server to send the browser to a simple Thank You page. When you see what the resulting page (including the URL) looks like, it should be pretty clear what's going on.
And with that, the last page of my killer app, we come to the end of this tutorial. I've given you the tools you need to create a relational database-driven Web site of your own. Now all that stands between you and the realization of your next bright idea is some hard work and a great deal of patience.
As you roll up your sleeves and start building tables and hammering out code, I'm off to practice curbing my wheels. Buena suerte, amigo.
