[SqlException (0x80131904): Incorrect syntax near '-'.
Incorrect syntax near the keyword 'ORDER'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1968874
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907547
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +293
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
Q.Object.Storage.Persistent.DB.Support.Q.Object.Storage.Persistent.IPersistantSupport.GetLookupIdentifications(Lookup lookup) +2684
[Exception: Fail to execute query : SELECT TBTW2.LN_Id, NEUTRAL0,NEUTRAL1 FROM (SELECT TOP -4 TBTW1.LN_Id, NEUTRAL0,NEUTRAL1 FROM (SELECT TOP 4 MAIN.LN_Id, MAIN.LN_Order AS NEUTRAL0 ,MAIN.LN_Id AS NEUTRAL1 FROM L_News AS MAIN WITH(NOLOCK) WHERE (0 = 0 AND MAIN.LN_Id in (Select LN_Id from L_News
inner join QD_N2N on N2N_Left=LN_Id and N2N_Relation='Local.Objects.News-WebParts.Objects.LocalizedText-LocalizedText'
inner join Q_W_LocalizedTextLanguage on WLTL_WLT_Id=N2N_Right and WLTL_QDLG_Id = 1 and WLTL_Title is not null and WLTL_Title!='') AND MAIN.LN_Active=@PARAM_0) ORDER BY MAIN.LN_Order DESC ,MAIN.LN_Id ASC) AS TBTW1 ORDER BY NEUTRAL0 ASC ,NEUTRAL1 DESC ) AS TBTW2 ORDER BY NEUTRAL0 DESC ,NEUTRAL1 ASC ]
Q.Object.Storage.Persistent.DB.Support.Q.Object.Storage.Persistent.IPersistantSupport.GetLookupIdentifications(Lookup lookup) +4517
Q.Object.Activator.Activator.Lookup(Lookup lookup) +130
WebSite.u.Pager.GetPagedDataSource() +41
WebSite.u.News.OnLoad(EventArgs e) +59
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
|