Server Error in '/' Application.

Column 'Products.ManufacturerId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

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: Column 'Products.ManufacturerId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Source Error:


Line 2043:	Dim daProducts As New SqlDataAdapter(strSqlProducts, myConnection)
Line 2044:	Dim dsProducts As New DataSet()
Line 2045:	daProducts.Fill(dsProducts)
Line 2046:	daProducts.Dispose()
Line 2047:	'*** start looping through the list of Products

Source File: C:\LocalUser\ftpRockyMtn\RockyMountainTrail.com\incControls\bodycontent.ascx    Line: 2045

Stack Trace:


[SqlException: Column 'Products.ManufacturerId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45
   System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
   ASP.bodycontent_ascx.subBoth() in C:\LocalUser\ftpRockyMtn\RockyMountainTrail.com\incControls\bodycontent.ascx:2045
   ASP.bodycontent_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\LocalUser\ftpRockyMtn\RockyMountainTrail.com\incControls\bodycontent.ascx:3077
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
   System.Web.UI.Page.ProcessRequestMain() +1926


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