VALUES子句中值的数目必须与INSERT语句中指定的列的数目匹配。

<%
dim username,password,notpassword,nicheng,xingming,shouji,yzm,sql,rs
username = trim(request.form("username"))
password = trim(request.form("password"))
notpassword = trim(request.form("notpassword"))
nicheng = trim(request.form("nicheng"))
xingming = trim(request.form("xingming"))
shouji = trim(request.form("shouji"))
yzm = trim(request.form("yzm"))

if cint(yzm) <> Session("CheckCode") then
call errorHistoryBack("验证码错误！")
end if
set rs = server.createobject("adodb.recordset")
sql = "select * from G_gou where G_zhanghao='"&username&"'"
rs.open sql,conn,1,1

password=md5(password)
sql = "INSERT INTO G_gou (G_zhanghao,G_mima,G_nicheng,G_xingming,G_shouji) VALUES ('"&username&"','"&password&"','"&nicheng&"','"&xingming&"','"&shouji&"',getdate())"
conn.execute(sql)
call close_conn

response.cookies("login")("username") = username

call sussLoctionHref("注册成功!","index.asp")

%>

是啊，insert明明才5列，values里面你给了6列值，多了一个getdate()吧

=@correctperson')", param) 最后那里多了一个 '' 号