语句未结束

spkl1 2008-03-22 07:08:20

<%
'入库开始
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&"')" '添加记录
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
...全文
47 点赞 收藏 11
写回复
11 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
jiewenxu 2008-03-22
把字符串分两行写看看
回复
myvicy 2008-03-22
想起来也遇到过这样的事情.&H
回复
spkl1 2008-03-22
[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
回复
spkl1 2008-03-22
改用 "',#"&birthday&"#,'" 后一样
回复
hookee 2008-03-22
& 和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&"')"
回复
myvicy 2008-03-22
而不是用单引号'
回复
兔子党-连长 2008-03-22
不应该啊
回复
myvicy 2008-03-22
如果字段是时间日期型的两边加##
回复
myvicy 2008-03-22
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
回复
spkl1 2008-03-22
提示指向 biethday 那里
回复
spkl1 2008-03-22
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 那里
回复
相关推荐
发帖
ASP
创建于2007-09-28

2.8w+

社区成员

ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
申请成为版主
帖子事件
创建了帖子
2008-03-22 07:08
社区公告
暂无公告