[SqlException (0x80131904): Incorrect syntax near the keyword 'and'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335264
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
System.Data.SqlClient.SqlDataReader.get_MetaData() +101
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +126
CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +254
[Exception:
[DataConnection.HandleError]:
Query:
select * from View_custom_NIRISponsors_Joined
WHERE (NodeParentId = and Published = 1)
Order by CompanyName ASC
Caused exception:
Incorrect syntax near the keyword 'and'.
]
CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) +229
CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +612
CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +446
CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +460
CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) +50
CMS.DataEngine.DataQueryBase`1.GetDataFromDB() +128
CMS.DataEngine.DataQueryBase`1.GetData() +126
CMS.DataEngine.DataQueryBase`1.get_Result() +112
CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +368
CMS.Controls.CMSAbstractQueryProperties.LoadData(Boolean forceReload, Int32 offset, Int32 maxRecords, Int32& totalRecords) +2196
CMS.Controls.CMSQueryDataSource.GetDataSource(Int32 offset, Int32 maxRecords) +173
CMS.Controls.CMSBaseDataSource.get_DataSource() +26
CMS.Controls.QueryRepeater.ReloadData(Boolean forceReload) +322
CMS.Controls.QueryRepeater.InitControl(Boolean loadPhase) +86
CMS.Controls.BasicRepeater.OnLoad(EventArgs e) +32
System.Web.UI.Control.LoadRecursive() +90
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533
|