实在不知道 啥原因ORA-00907: 缺少右括号
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: ORA-00907: 缺少右括号源错误:
行 20: 'Dim cmd1 As New Data.SqlClient.SqlCommand("select userid,username,truename, online,(select count(id) from chat where dusername='" & Trim(Session.Item("curuser_username")) & "' and susername=qx_users.username and readed='0') as msgcount from qx_users order by online desc", connmy)
行 21: Me.TblUser.Rows.Clear()
行 22: Using dr1 As OleDb.OleDbDataReader = cmd1.ExecuteReader
行 23: Do While dr1.Read
行 24: Dim row1 As New TableRow
源文件: E:\厦门车管\CLJSGL\Chatmain.aspx.vb 行: 22 堆栈跟踪:
[OleDbException (0x80040e14): ORA-00907: 缺少右括号]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +114
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +163
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +92
System.Data.OleDb.OleDbCommand.ExecuteReader() +6
Chartmain.LoadUserList() in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:22
Chartmain.Page_Load(Object sender, EventArgs e) in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:62
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: ORA-00907: 缺少右括号源错误:
行 20: 'Dim cmd1 As New Data.SqlClient.SqlCommand("select userid,username,truename, online,(select count(id) from chat where dusername='" & Trim(Session.Item("curuser_username")) & "' and susername=qx_users.username and readed='0') as msgcount from qx_users order by online desc", connmy)
行 21: Me.TblUser.Rows.Clear()
行 22: Using dr1 As OleDb.OleDbDataReader = cmd1.ExecuteReader
行 23: Do While dr1.Read
行 24: Dim row1 As New TableRow
源文件: E:\厦门车管\CLJSGL\Chatmain.aspx.vb 行: 22 堆栈跟踪:
[OleDbException (0x80040e14): ORA-00907: 缺少右括号]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +114
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +163
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +92
System.Data.OleDb.OleDbCommand.ExecuteReader() +6
Chartmain.LoadUserList() in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:22
Chartmain.Page_Load(Object sender, EventArgs e) in E:\厦门车管\CLJSGL\Chatmain.aspx.vb:62
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750
可能是缺少括号原因的,仔细检查。