Server Error in '/' Application.
Incorrect syntax near the keyword 'AND'.
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.OleDb.OleDbException: Incorrect syntax near the keyword 'AND'.
Source Error:
Line 41: Else
Line 42: myAdapter.SelectCommand.CommandText = "SELECT Top 250 * FROM tblNews WHERE AND ({ fn NOW() } >= StartDate) AND (Publish = '1' OR Publish = '2') And Active = 'Y' Order By TID Desc;"
Line 43: myAdapter.Fill(rsNews)
Line 44: End If
Line 45: %>
Source File: C:\inetpub\wwwroot\AlgoaFM\articles.aspx Line: 43
Stack Trace:
[OleDbException (0x80040e14): Incorrect syntax near the keyword 'AND'.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1849301
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +415
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +243
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +278
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +281
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +9
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +325
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +504
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +324
ASP.articles_aspx.__RenderContent5(HtmlTextWriter __w, Control parameterContainer) in C:\inetpub\wwwroot\AlgoaFM\articles.aspx:43
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +131
ASP.masterpage_master.__Renderform1(HtmlTextWriter __w, Control parameterContainer) in C:\inetpub\wwwroot\AlgoaFM\MasterPage.master:769
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +131
System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +315
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
ASP.masterpage_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:\inetpub\wwwroot\AlgoaFM\MasterPage.master:163
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +131
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
System.Web.UI.Page.Render(HtmlTextWriter writer) +40
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5290
their webmaster is asleep at the wheel. They issue an alert about load shedding dated 2 November 2014 which contains details of the current LS schedule. I wrote to them yeasterday and again today but they don't take any remedial action. If anybody in PE knows this Oke, please give him a nudge.
