on page 717 the book has me insert some new lines. Here are the important ones:
Set orsPendingSales = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT SaleID, WinningBid, ItemName " & _
"FROM Sale " & _
"INNER JOIN Item ON Sale.ItemID = Item.ItemID " & _
"WHERE BuyerID=" & Session("PersonID") & " " & _
orsPendingSales.Open sSQL, oConn
When I execute the login I receive an error on the last line above:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/begasp/chap15/MenuForRegisteredUsers.asp, line 51
I am using Windows 2000 spk4 with IIS updates. Since I have used just enough of SQL syntax to understand what it is asking for I do not know if the syntax is correct for Access 2000 or MSSQL. I am using Access 2000.
Richard J. Airhart