Fejl i linie bla bla...
Jeg har en side hvor der er følgende link:<a href="ViewOrderDetails2.asp?qryID=<%= ID %>"><%= ID %> (Hvad er der bestilt, klik her)</a> Der hentes så ud fra en database, ID, så det bliver til: ViewOrderDetails2.asp?qryID=12.
Når den så kommer til næste sider, melder den:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/ViewOrderDetails2.asp, line 31
den side ser sådan her ud:
<%
Option Explicit
Sub DrawPage()
%>
<html>
<head>
<meta http-equiv="Content-Style-Type" content="text/css">
<title>Bestillings detaljer</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<table border="1" rules="groups" cellspacing="0" cellpadding="0" bordercolor="black" style="background: #CCCCCC">
<tr><td><img src="gfx/top.gif"></td></tr>
<tr>
<td><center><font size=5>
Oversigt over bestilling nr. <%= OrderID %></font>
<br><br>
<table border=0 align="center">
<tr style="background: #0569B2" align="center">
<TD width=250><font color=white>Navn</font></TD>
<TD width=75><font color=white>Pris </font></TD>
<TD width=75><font color=white>Antal</font></TD>
<TD width=75><font color=white>Total</font></TD>
</tr>
<%
while not rs.EOF
rs.MoveFirst
ID = rs("OrderID") & ""
Name = rs("navn") & ""
price = rs("Price") & ""
quantity = rs("Quantity") & ""
itemSubTotal = price * quantity
totalCost = totalCost + itemSubTotal
If price <> "" then
price = FormatCurrency(price)
End If
%>
<TR align="center">
<TD><%= Name %> </TD>
<TD><%= price %> </TD>
<TD><%= quantity %> </TD>
<TD><%= FormatCurrency(itemSubTotal) %> </TD>
</TR>
<%
rs.MoveNext
wend
%>
</TABLE>
<br>
<hr>
<a href="java script:history.back()">En side tilbage</a> - <a href="cart.asp">Se indkøbskurven</a> - <a href="index2.asp">Tilbage til hovedsiden</a>
<td>
<tr>
</table>
</div>
</body>
</html>
<%
End Sub
dim rs
dim sqlString
dim connectionString, databaseName, path
dim OrderID, ID, Name, price, quantity, itemSubTotal, totalCost
OrderID = request.querystring("qryID")
path = Server.MapPath(".")
databaseName = "data.mdb"
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& path & "\" & databaseName
sqlString = "select * from OrderDetails, Orders " & _
" where OrderDetails.ProductID=Orders.OID " & _
" AND OrderID=" & OrderID
sqlString = sqlString & " Order By navn"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sqlString, connectionString
Call DrawPage()
rs.Close
Set rs = Nothing
%>
linie 31 er:
rs.MoveFirst
