南街8号画室:sql语句 insert into 错误

来源：百度文库编辑：神马品牌网时间：2024/04/28 06:11:47

<%
call checkFlag()
Select Case trim(request("submit"))
Case "是"
'if trim(request("del"))="是" then
Conn.Execute "Delete * From [user] Where UserID="&trim(Request("UserID"))
Conn.Close()
set Conn=Nothing
Call Finished()
Case "修改"
'elseif trim(request("modify"))="修改" then
on error resume next
sql="select flag,lockuser from [user] where userid="&request("userid")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
rs(0)=ltrim(request("flag"))
rs(1)=request("lockuser")
rs.update
rs.close()
Conn.Close()
set Conn=Nothing
Call Finished()
Case "增加"
'elseif trim(request("submit"))="增加" then
if trim(request("username"))="" or trim(request("password"))="" then
response.write "<script>alert('用户名称和密码不能为空');history.go(-1)</script>"
else
set Rs=conn.execute("Select username From [user] where username='"&trim(request("username"))&"'")
if Not Rs.eof then
conn.execute("update [user] set flag="&request("flag")&" where username='"&checkstr(trim(request("Username")))&"'")
else
conn.execute "insert into [user] (username,sex,password,LastLoginIP,Flag) values ('"&trim(request("username"))&"',"&request("sex")&",'"&md5(trim(request("password")))&"','"&request("UserIP")&"',"&request("flag")&")"
end if
Conn.Close()
set Conn=Nothing
Call Finished()
end if
Case else
Response.Redirect "admin_usermanage.asp"
End Select
'end if
sub Finished()
%>
<html>
<head>
<title>修改成功</title>
<meta http-equiv="refresh" content='2; URL=admin_usermanage.asp'>
</head>
<body>
<p align="center">操作成功！请继续别的操作。</p>
<%
end sub
%>

我在添加用户时候提示如下，请高手回答
在线等

技术信息（用于支持人员）

错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/wzb/admin_editusermanage.asp, 第 36 行conn.execute "insert into [user] (username,sex,password,LastLoginIP,Flag) values ('"&trim(request("username"))&"',"&request("sex")&",'"&md5(trim(request("password")))&"','"&request("UserIP")&"',"&request("flag")&")"

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

网页：
POST 69 ??? /wzb/admin_editusermanage.asp

POST Data:
username=1111&sex=1&password=123456789&Flag=1&Submit=%D4%F6%BC%D3

insert into [user] ([username],sex,[password],LastLoginIP,[Flag])

sql语句 insert into 错误说明SQL语句INSERT INTO dept VALUES 说明SQL语句INSERT INTO dept VALUES sql语句insert into 语法问题很简单的 INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误 SQL INSERT语句 SQl 的INSERT语句