Beregning
Hvorfor virker min beregning ikke??Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT customers.*, orders.*, products.*, oitems.* FROM (customers INNER JOIN orders ON customers.custID = orders.ocustomerid) INNER JOIN (products INNER JOIN oitems ON products.catalogID = oitems.catalogid) ON orders.orderID = oitems.orderid;"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Dim antal, pris, total
antal = rs("numitems")
pris = rs("cprice")
total = antal*pris
Response.Write "<table width=400 cellpadding=1>"
do While Not rs.EOF
Response.write "<tr class=text><td>" & rs("Clastname") & "</td><td>" & rs("cfirstname") & "</td><td>" & rs("cname") & "</td><td>" & rs("numitems") & "</td><td>" & total & "</td></tr>"
