AbleCommerce Shopping Cart Software

Code: Select all

Ambiguous column name 'OrderId'. 
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: Ambiguous column name 'OrderId'.

Source Error: 


Line 75:     {
Line 76:         CouponSummary summary = (CouponSummary)dataItem;
Line 77:         return OrderDataSource.LoadForCouponCode(summary.CouponCode, summary.StartDate, summary.EndDate, "OrderId ASC");
Line 78:     }
Line 79: </script>
 

Source File: d:\....\Admin\Reports\CouponUsageDetail.aspx    Line: 77 

Stack Trace: 


[SqlException (0x80131904): Ambiguous column name 'OrderId'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.get_MetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +7
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +133
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +143
   CommerceBuilder.Orders.OrderDataSource.LoadForCouponCode(String couponCode, DateTime startDate, DateTime endDate, String sortExpression) +1045
   ASP.admin_reports_couponusagedetail_aspx.GetCouponOrders(Object dataItem) in d:\...\Admin\Reports\CouponUsageDetail.aspx:77
   ASP.admin_reports_couponusagedetail_aspx.__DataBinding__control21(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:162
   System.Web.UI.Control.OnDataBinding(EventArgs e) +99
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +47
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.Control.DataBindChildren() +204
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
   System.Web.UI.Control.DataBind() +12
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +130
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +454
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   ASP.admin_reports_couponusagedetail_aspx.ReportButton_Click(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:70
   ASP.admin_reports_couponusagedetail_aspx.Page_Load(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:35
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436