Server Error in '/' Application.

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

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.Exception: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.]
   QX.DAL.DbHelperOleDb.Query(String SQLString) +263
   QX.DAL.GetPager.GetWherePagelist(String FieldID, String showFields, String DataTableName, Int32 pageSize, Int32 currentPageIndex, String strWhere, String OrderFieldID, Int32 OrderFlag) +1029
   QX.BLL.Pager.GetWherePagelist(String FieldID, String showFields, String DataTableName, Int32 pageSize, Int32 currentPageIndex, String strWhere, String OrderFieldID, Int32 OrderFlag) +110
   QX.Web.HotelList.Bind() in E:\share\Magvacations.net\WebApp\HotelList.aspx.cs:43
   QX.Web.HotelList.Page_Load(Object sender, EventArgs e) in E:\share\Magvacations.net\WebApp\HotelList.aspx.cs:27
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.8966; ASP.NET Version:2.0.50727.8962