语句未结束

[spkl1]

<%
'入库开始
dim guest_sex,nation,belief,birthday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content
guest_sex=request("sex")
nation=request("nation")'民族
belief=request("")'信仰
birthday=request("year")&"-"&request("month")&"-"&request("day")'出生年月
height=request("height")'身高
marriagestatus=request("marriagestatus")'婚姻状况
education=request("education")'教育程度
job=request("job")'工作
income=request("income")'收入
area=request("area")&" "&request("cc") '居住地
tel=request("tel")'电话
guest_email=request("guest_email")'游客邮箱
msn=request("msn")
qq=request("qq")
content=request("content")'应征信内容
addtime=now()

conn.execute "insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"&height&"','"&marriagestatus&"','"&education&"','"&job&"','"&income&"','"&area&"','"&tel&"','"&guest_email&"','"&msn&"','"&qq&"','"&content&"','"&addtime&"')" '添加记录
%>

页面提示错误:

Microsoft VBScript 编译器错误 错误 '800a0401'

语句未结束

/free_gbook1.asp，行 65

conn.execute "insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"&height&"','"&marriagestatus&"','"&education&"','"&job&"','"&income&"','"&area&"','"&tel&"','"&guest_email&"','"&msn&"','"&qq&"','"&content&"','"&addtime&"')" '添加记录
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^

[spkl1]

Microsoft VBScript 编译器错误 错误 '800a0401'

语句未结束

/free_gbook1.asp，行 65

conn.execute "insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"&height&"','"&marriagestatus&"','"&education&"','"&job&"','"&income&"','"&area&"','"&tel&"','"&guest_email&"','"&msn&"','"&qq&"','"&content&"','"&addtime&"')" '添加记录
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^


提示指向 biethday 那里

[spkl1]

提示指向 biethday 那里

[myvicy]

sql_inst="insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"&height&"','"&marriagestatus&"','"&education&"','"&job&"','"&income&"','"&area&"','"&tel&"','"&guest_email&"','"&msn&"','"&qq&"','"&content&"','"&addtime&"')" '添加记录
response.write sql_inst
conn.execute sql_inst

[myvicy]

如果字段是时间日期型的两边加##

[tantaiyizu]

不应该啊

[myvicy]

而不是用单引号'

[hookee]

& 和h之间要有空格。&h是表示16进制
"..."&height&"..." 改为 "..." & height & "..."

conn.execute "insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"& height &"','"&marriagestatus&"','"&education&"','"&job&"','"&income&"','"&area&"','"&tel&"','"&guest_email&"','"&msn&"','"&qq&"','"&content&"','"&addtime&"')"

[spkl1]

改用 "',#"&birthday&"#,'" 后一样

[spkl1]

[Quote=引用 7 楼 hookee 的回复:]
& 和h之间要有空格。&h是表示16进制
"..."&height&"..." 改为 "..." & height & "..."

conn.execute "insert into love_gbook(username,senduser,kind,title,sex,nation,belief,birthyday,height,marriagestatus,education,job,income,area,tel,guest_email,msn,qq,content,addtime)values('"&acceptuser&"','"&senduser&"','应征信','"&title&"','"&guest_sex&"','"&nation&"','"&belief&"','"&birthday&"','"& height &"…
[/Quote]




OK

[myvicy]

想起来也遇到过这样的事情.&H

[jiewenxu]

把字符串分两行写看看