Server Error in '/' Application.

Cannot find column [id].

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.EvaluateException: Cannot find column [id].

Source Error:


Line 337:            DataTable dtAuthorBooks = sh.performAdvancedSearch("id = 0 UNION SELECT TOP 3 b.*, sbp.price AS specialBookPrice FROM books b LEFT JOIN (SELECT isbnNumber, price FROM specialBookPrices WHERE isActive = 1) sbp ON sbp.isbnNumber = b.isbn13 WHERE ([isActive] = 1) AND ([contributorName] = '" + book.ContributorName + "' OR [contributor2Name] = '" + book.ContributorName + "')");
Line 338:
Line 339:            dtAuthorBooks.DefaultView.RowFilter = "id <> " + bookID;
Line 340:
Line 341:            dtAuthorBooks.DefaultView.Sort = "publicationDate DESC";

Source File: c:\Home\searchpress.com\www\product-digital.aspx.cs    Line: 339

Stack Trace:


[EvaluateException: Cannot find column [id].]
   System.Data.NameNode.Bind(DataTable table, List`1 list) +263
   System.Data.BinaryNode.Bind(DataTable table, List`1 list) +48
   System.Data.DataExpression.Bind(DataTable table) +116
   System.Data.DataView.set_RowFilter(String value) +194
   product_digital.Page_Load(Object sender, EventArgs e) in c:\Home\searchpress.com\www\product-digital.aspx.cs:339
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   BasePage.OnLoad(EventArgs e) in c:\Home\searchpress.com\www\App_Code\BasePage.cs:114
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4057.0