Modify itemdata.asp (Fig. 26.19) to prevent seller from bidding on their items. If a seller attempts to do this, redirect them to cannotbid.html, which displays an alert message. Write cannotbid.html.

What will be an ideal response?


```

1 <% @LANGUAGE = VBSCRIPT %>

2 <% Option Explicit %>

3

4 <% ' itemdata.asp %>

5

6 <% Dim connection, query, data, seller

7

8 ' Open a database connection

9 Set connection = Server.CreateObject( "ADODB.Connection" )

10 Call connection.Open( "DeitelAuctions" )

11

12 ' Create the SQL query. Retrieve the selected item.

13 query = "SELECT * FROM AuctionItems WHERE ItemNumber = " _

14 & CStr( Request( "ItemNumber" ) )

15

16 ' Open the record set

17 Set data = Server.CreateObject( "ADODB.RecordSet" )

18 Call data.Open( query, connection )

19 On Error Resume Next

20

21 ' Save the item number in a session variable for the

22 ' bidding page.

23 Session( "ItemNumber" ) = data( "ItemNumber" )

24 %>

25

26

27

28

29 Item Description

30

31

32

Item Description




33



34 <% ' Display the item

Computer Science & Information Technology

You might also like to view...

An operation that copies a value into a variable is called a(n) ________ operation.

A) assignment B) equals C) copy D) declaration E) cout

Computer Science & Information Technology

A(n) ____________________ configuration enables you to install multiple OSs on one computer and choose which one to use when you start the computer.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

In a form or subform, records are sorted by the ________

A) primary key field B) foreign key field C) filter D) date field

Computer Science & Information Technology

The 1 in the expression *(gPtr + 1) is a(n) ____.

a. pointer b. initializer c. offset d. register

Computer Science & Information Technology