Server Error in '/crafts' Application.

Syntax error (missing operator) in query expression 'p_id= AND p_id<>0 AND c_id<>708 AND status=-1'.

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: Syntax error (missing operator) in query expression 'p_id= AND p_id<>0 AND c_id<>708 AND status=-1'.

Source Error:


Line 163:odAdapt1 = New OleDbDataAdapter(sqlCom1, dbconnC1)
Line 164:DS1 = New DataSet
Line 165:odAdapt1.Fill(DS1)
Line 166:DT1 = DS1.Tables(0)
Line 167:dim n1 = DT1.Rows.Count

Source File: D:\website\webindia123\map.craft\howtomake.aspx    Line: 165

Stack Trace:


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'p_id= AND p_id<>0 AND c_id<>708 AND status=-1'.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1217021
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +256
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +216
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +60
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +164
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +115
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   ASP.howtomake_aspx.Page_Load() in D:\website\webindia123\map.craft\howtomake.aspx:165
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +9850746
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4676.0