关于insert into语句未结束

来源:百度知道 编辑:UC知道 时间:2024/06/16 09:44:10
<!-- #include file="conn.asp" -->
<%
username = request("username") : dearname = request("dearname") : userpwd = request("userpwd") : pwen = request("pwen")
yy = request("yy") : mm = request("mm") : dd = request("dd")
youbian = request("youbian") : yx = request("yx") : phone = request("phone") : homephone = request("homephone")
sqlcmd = "insert into 用户信息(username,dearname,userpwd,pwen,yy,mm,dd,youbian,yx,phone,homephone) values('"&username&"','"&dearname&"','"&userpwd&"','"&pwen&"','"&yy&"','"&mm"','"&dd&"',"&youbian&','"&yx&"',"&phone&","&homephone&")"
cnObj.execute sqlcmd
cnObj.close
set cnObj=nothing
%>
conn.asp代码:
<

sqlcmd = "insert into 用户信息(username,dearname,userpwd,pwen,yy,mm,dd,youbian,yx,phone,homephone) values('"&username&"','"&dearname&"','"&userpwd&"','"&pwen&"','"&yy&"','"&mm&"','"&dd&"',"&youbian&','"&yx&"',"&phone&","&homephone&")"
mm后面少了一个连接符号

"," 逗号的问题。。。,逗号打在引号外面了。。
---------------------------------------
就是values 后面的逗号