0001: <%@ Language="VBScript" %> 0002: 0003: 0005: 0006: 0007: <% set conn = server.createobject("ADODB.connection") 0008: conn.open "warehouse", "IWSDStudent", "assign2" 0009: sql = "select * from orderInfo 0010: set rs = conn.execute(sql)%> 0011: 0012: task 6 0013: 0014: 0015: 0016: 0017:

Order Info Table

0018: 0019: 0020: 0021: 0022: 0023: 0024: 0025: 0026: <% do while not rs.eof %> 0027: 0028: 0029: 0030: 0031: 0032: 0033: 0034: 0035: <% rs.movenext 0036: loop%> 0037:
Order NumberLine item IDProduct CodeQuantity Ordered
<%= rs("orderNumber")%><%= rs("lineItemID")%><%= rs("productCode")%><%= rs("quantityOrdered")%>
0038: <% set conn = server.createobject("ADODB.connection") 0039: conn.open "warehouse", "IWSDStudent", "assign2" 0040: sql = "select * from orders" 0041: set rs = conn.execute(sql)%> 0042:

Order Table

0043: 0044: 0045: <% set conn = server.createobject("ADODB.connection") 0046: conn.open "warehouse", "IWSDStudent", "assign2" 0047: sql = "select * from orders" 0048: set rs = conn.execute(sql)%> 0049:
0050: 0051: 0052: 0053: 0054: 0055: 0056: 0057: 0058: 0059: <% do while not rs.eof %> 0060: 0061: 0062: 0063: 0064: 0065: 0066: 0067: 0068: 0069: <% rs.movenext 0070: loop%> 0071:
Order NumberCustomer IDOrder DateShipping date Shipped Staff ID
<%= rs("orderNumber")%><%= rs("customerID")%><%= rs("orderDate")%><%= rs("shippingDate")%><%= rs("shipped")%><%= rs("staffID")%>
0072: <% set conn = server.createobject("ADODB.connection") 0073: conn.open "warehouse", "IWSDStudent", "assign2" 0074: sql = "select * from product" 0075: set rs = conn.execute(sql)%> 0076:

Product Table

0077: 0078: 0079: 0080: 0081: 0082: 0083: 0084: 0085: 0086: <% do while not rs.eof %> 0087: 0088: 0089: 0090: 0091: 0092: 0093: 0094: <% rs.movenext 0095: loop%> 0096:
Prodcut CodeNameQuantity On handPrice
<%= rs("productCode")%><%= rs("name")%><%= rs("quantityOnHand")%><%= rs("price")%>
0097: 0098: <% set conn = server.createobject("ADODB.connection") 0099: conn.open "warehouse", "IWSDStudent", "assign2" 0100: sql = "select * from staff" 0101: set rs = conn.execute(sql)%> 0102:

Staff Table

0103: 0104: 0105: 0106: 0107: 0108: 0109: 0110: <% do while not rs.eof %> 0111: 0112: 0113: 0114: 0115: 0116: <% rs.movenext 0117: loop%> 0118:
Staff IDName
<%= rs("staffID")%><%= rs("name")%>
0119: 0120: 0121: