Active Server Pages 3.0 from Scratch

Seeing Our Auctions

Now that we have finally succeeded in saving an item for auction, go ahead and add a few more.

Next we're going to get a list of all of the items that are available for sale. At first, we'll make this a general list. A little later, we'll make it more generic it so we can use it for multiple purposes.

Copy template.asp to auction_listitems.asp in the auction directory and add the code shown in Listing 6.13.

Code Listing 6.13. auction_listitems.asp: Getting a list of all auction items

0: <%@ LANGUAGE="VBSCRIPT" %> 1:<!--#include file="adovbs.inc"--> 2: <% pageTitle = "Outpost Auction Block" %> 3:<!--#include virtual="/pagetop.txt"--> 4:<% 5: set outpostDB = Server.CreateObject("ADODB.Connection") 6: outpostDB.Open "outpost" ...