'/' 應用程式中發生伺服器錯誤。

查詢運算式 '((selltime1 <= #2024/3/29# kind='4' and lan_kind='T') AND (selltime2 >= #2024/3/29# kind='4' and lan_kind='T')) or (isnull(selltime1) kind='4' and lan_kind='T') or (isnull(selltime2) kind='4' and lan_kind='T')' 中的 語法錯誤 (少了運算元)。

描述: 在執行目前 Web 要求的過程中發生未處理的例外情形。請檢閱堆疊追蹤以取得錯誤的詳細資訊,以及在程式碼中產生的位置。

例外詳細資訊: System.Data.OleDb.OleDbException: 查詢運算式 '((selltime1 <= #2024/3/29# kind='4' and lan_kind='T') AND (selltime2 >= #2024/3/29# kind='4' and lan_kind='T')) or (isnull(selltime1) kind='4' and lan_kind='T') or (isnull(selltime2) kind='4' and lan_kind='T')' 中的 語法錯誤 (少了運算元)。

原始程式錯誤:


行 58:         AccessDataSource ads = new AccessDataSource(db, sql_data);
行 59:         DataView dv = new DataView();
行 60:         dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
行 61: 
行 62:         if (Session["page"] != null)

原始程式檔: d:\Inetpub\vhosts\furelin.com.tw\httpdocs\web_02\html\news\index.aspx.cs    行: 60

堆疊追蹤:


[OleDbException (0x80040e14): 查詢運算式 '((selltime1 <= #2024/3/29# kind='4' and lan_kind='T') AND (selltime2 >= #2024/3/29# kind='4' and lan_kind='T')) or (isnull(selltime1) kind='4' and lan_kind='T') or (isnull(selltime2) kind='4' and lan_kind='T')' 中的 語法錯誤 (少了運算元)。]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1005708
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +116
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
   System.Web.UI.WebControls.AccessDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +58
   System.Web.UI.WebControls.SqlDataSource.Select(DataSourceSelectArguments arguments) +19
   web_02_html_news_index.UpdateData() in d:\Inetpub\vhosts\furelin.com.tw\httpdocs\web_02\html\news\index.aspx.cs:60
   web_02_html_news_index.Page_Load(Object sender, EventArgs e) in d:\Inetpub\vhosts\furelin.com.tw\httpdocs\web_02\html\news\index.aspx.cs:18
   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


版本資訊: Microsoft .NET Framework 版本:2.0.50727.8974; ASP.NET 版本:2.0.50727.8975