以下是我的语句。但执行的时候却出现这样的错误。<%
strConnection = "dsn=mysql;driver={myodbd driver};server=localhost;uid=root;pwd=;database=proto_management_test"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConnection
%>
<%
id = request("id")
newname = request("newname")
sql="UPDATE project_m SET project_name = "&newname&" WHERE project_id = "&id&""
conn.execute(sql)
conn.close:set conn = nothing
response.Redirect("projmodify.asp")
%>错误:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.36-community]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 'WHERE project_id = 1' at line 1
/Marelli/copy_Marelli/prj_saveprjid.asp, 第 17 行请各位大侠们帮忙帮忙 。谢谢。
strConnection = "dsn=mysql;driver={myodbd driver};server=localhost;uid=root;pwd=;database=proto_management_test"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConnection
%>
<%
id = request("id")
newname = request("newname")
sql="UPDATE project_m SET project_name = "&newname&" WHERE project_id = "&id&""
conn.execute(sql)
conn.close:set conn = nothing
response.Redirect("projmodify.asp")
%>错误:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 5.1 Driver][mysqld-5.1.36-community]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 'WHERE project_id = 1' at line 1
/Marelli/copy_Marelli/prj_saveprjid.asp, 第 17 行请各位大侠们帮忙帮忙 。谢谢。
id = request("id")
newname = request("newname")
sql="UPDATE project_m SET project_name = "&newname&" WHERE project_id = "&id&""
response.write sql
response.end
conn.execute(sql)
conn.close:set conn = nothing
response.Redirect("projmodify.asp")
%>看一下你这句SQL内容是什么?经验上看,你估计是少了引号如果你的project_name字符是varchar型的话。
sql="UPDATE project_m SET project_name = '"&newname&"' WHERE project_id = "&id&""如果 project_id 也是字符型,则也需要加上 '
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
是PHP语法吗
sql="UPDATE project_m SET project_name = "+&newname&+" WHERE project_id = "+&id&;
java语法
都用空格隔开
response.end显示的结果是什么?
我知道了 newname的参数没有传递到。
<a onclick="return confirm('确定要保存数据吗?。');"href="prj_saveprjid.asp?id=<%=Recordset1.Fields.Item("project_id").Value%>&newname=<%request.form("projectname")%>">Save</a>为什么我request.form("projectname")传递不了参数呢?
newname= <%request.form("projectname")%>
看看这个到底等于什么?
project_name