Server Error in '/' Application.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

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.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Source Error:


Line 57:             if (Trace.IsEnabled) Trace.Write(strSqlStmt);
Line 58:             SqlDataReader objRS = idSQL.rtnSQLdata(objDBConn, strSqlStmt);
Line 59:             if (objRS.Read())
Line 60:             {
Line 61:                 redirectAddress = objRS["VIRTUAL_URL"].ToString();

Source File: E:\websites\VisitBlackpool\Live\Public\404.aspx Line: 59

Stack Trace:


[SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.]
   System.Data.SqlClient.SqlDataReader.Read() +176
   ASP._404_aspx.Page_Load() in E:\websites\VisitBlackpool\Live\Public\404.aspx:59
   System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +10
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +744

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300