Create an Active Server Page that creates an XML document from the following database:


```
1 <%
2 @Language = "VBScript"
3 Option Explicit
4
5 ' Exercise 27.15 solution
6
7 Dim objConn, objRS
8
9 Set objConn = Server.CreateObject( "ADODB.Connection" )
10 Call objConn.Open( "DSN=productDB;" )
11
12 Set objRS = Server.CreateObject( "ADODB.Recordset" )
13
14 Call objRS.Open( "SELECT * FROM products ORDER BY productName", objConn )
15 %>
16
17
18
19 <%
20 While Not objRS.EOF
21 %>
22
23 <% =objRS( "productID" ) %>
24 <% =objRS( "productName" ) %>
25

26 <%
27 objRS.MoveNext
28 Wend
29
30 Call objRS.Close
31 Call objConn.Close
32 Set objRS = Nothing
33 Set objConn = Nothing
34 %>
35

```

Computer Science & Information Technology

You might also like to view...

The classpath consists of a list of directories or archive files, each separated by a ________ on Windows or a ________ on UNIX/Linux/Max OS X.

a. colon (:), semicolon (;). b. semicolon (;), colon (:). c. comma (,), semicolon (;). d. semicolon (;), comma (,).

Computer Science & Information Technology

What is the purpose of intelligent placement?

A. to determine compatibility for VMM installation B. it selects the best server for deploying VMM components C. it selects the best volume for storing virtual disks D. to choose the best host for virtual machine deployment

Computer Science & Information Technology

Because a wireless signal can only be transmitted for several hundred feet, multiple APs are used to provide "cells" or areas of coverage.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The Resource Usage view shows you all of the following for each resource EXCEPT ____.

A. baseline cost B. variance C. key cost D. remaining cost

Computer Science & Information Technology