“/”应用程序中的服务器错误。--------------------------------------------------------------------------------YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondsto...
“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1
源错误:
行 84: Dim cmd2 As New MySqlCommand(str,conn)
行 85: conn.Open()
行 86: Dim dr2 As MySqlDataReader = cmd2.ExecuteReader()
行 87: DataList_danxuanti.DataSource = dr2
行 88: DataList_danxuanti.DataBind()
源文件: c:\inetpub\wwwroot\kaoshi.aspx.vb 行: 86
堆栈跟踪:
[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1]
MySql.Data.MySqlClient.MySqlStream.OpenPacket() +238
MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +60
MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +49
MySql.Data.MySqlClient.MySqlDataReader.NextResult() +724
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +930
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +6
students_kaoshi.shengchengshiti_danxuanti() in c:\inetpub\wwwroot\kaoshi.aspx.vb:86
students_kaoshi.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\kaoshi.aspx.vb:310
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
代码是
我在命令提示符下执行mysql> select * from danxuanti where danxuanti_id=7 or danxuanti_id=5 or danxuanti_id=6;
返回数据正常啊!
Dim str As String
str = "select * from duoxuanti where duoxuanti_id=" & tihao_duoxuanti(1)
For i = 2 To nn
str &= "or duoxuanti_id=" & tihao_duoxuanti(i)
Next
Dim cmd2 As New MySqlCommand(str, conn)
conn.Open()
Dim dr2 As MySqlDataReader = cmd2.ExecuteReader()
DataList_duoxuanti.DataSource = dr2
DataList_duoxuanti.DataBind()
conn.Close()
End Sub
展开