您所在位置：主题：哪位大虾好心帮我看一下这ＳＱＬ语句错哪了？
bubble4001
[专家分：0] 发布于 2007-04-19 02:54:00
我这里要实现的是注册登陆成功以后把输入的资料添加入该用户相对应的位置上，可是却出错了．．
以下是该页面的源代码．
[color=0000FF]<!--#include file="conn.asp"-->
<%
name=request("name")
idcard=request("idcard")
sex=request("sex")
byear=request("byear")
bmonth=request("bmonth")
bday=request("bday")
hukou=request("hukou")
juzhu=request("juzhu")
phone=request("phone")
oicq=request("oicq")
website=request("website")
address=request("address")
postcode=request("postcode")
major=request("major")
major1=request("major1")
college=request("college")
degree=request("degree")
language1=request("language1")
level1=request("level1")
language2=request("language2")
level2=request("level2")
years=request("years")
jobaddress1=request("jobaddress1")
jobaddress2=request("jobaddress2")
salary=request("salary")
job=request("job")
inresume=request("inresume")
Set rs=server.CreateObject("adodb.recordset")
sql="insert into in_user(name,idcard,sex,byear,bmonth,bday,hukou,juzhu,phone,oicq,website,address,postcode,major, major1,college,degree,language1,level1,language2,level2,years,jobaddress1,jobaddress2,salary,job,inresume)
value('"&amp;("name")&amp;"',
'"&amp; ("idcard")&amp;"','"&amp; ("sex")&amp;"','"&amp;("byear")&amp;"','"&amp; ("bmonth")&amp;"','"&amp;("bday")&amp;"','"&amp;("hukou")&amp;"',
'"&amp;("juzhu")&amp;"',"&amp;("phone")&amp;"','"&amp;("oicq")&amp;"','"&amp;("website")&amp;"','"&amp;("address")&amp;"',
'"&amp;("postcode")&amp;"','"&amp;("major")&amp;"','"&amp;("major1")&amp;"','"&amp;("college")&amp;"','"&amp;("degree")&amp;"',
'"&amp;("language1")&amp;"','"&amp;("level1")&amp;"','"&amp;("language2")&amp;"','"&amp;"level2")&amp;"','"&amp;("years")&amp;"',
'"&amp;("jobaddress1")&amp;"','"&amp;"jobaddress2")&amp;"','"&amp;("salary")&amp;"','"&amp;("job")&amp;"',
'"&amp;("inresume")&amp;"')where id="&amp;clng(session("id"))
rs.open sql,conn,1,1
rs.close
response.write "<script language=JavaScript>" &amp; chr(13) &amp; "alert('详细资料已完善！');"&amp;"window.location.href = 'in_center.asp'"&amp;" </script>"
%>[/color]
[color=FF0000]错误类型：
Microsoft VBScript 编译器错误 (0x800A0409)
未结束的字符串常量
/招聘网/members/in_handle1.asp, line 33, column 308
sql="insert into in_user(name,idcard,sex,byear,bmonth,bday,hukou,juzhu,phone,oicq,website,address,postcode,major,major1,college,degree,language1,level1,language2,level2,years,jobaddress1,jobaddress',salary,job,inresume) value('"&("name")&"','"& ("idcard")&"','"& ("sex")&"','"&("byear")&"','"& ("bmonth")&"',
-------------------------------------------------[/color]
看了半天也不知道是怎么一回事．．．郁闷啊．．．[em10][em10][em10]
以下是该页面的源代码．
[color=0000FF]<!--#include file="conn.asp"-->
<%
name=request("name")
idcard=request("idcard")
sex=request("sex")
byear=request("byear")
bmonth=request("bmonth")
bday=request("bday")
hukou=request("hukou")
juzhu=request("juzhu")
phone=request("phone")
oicq=request("oicq")
website=request("website")
address=request("address")
postcode=request("postcode")
major=request("major")
major1=request("major1")
college=request("college")
degree=request("degree")
language1=request("language1")
level1=request("level1")
language2=request("language2")
level2=request("level2")
years=request("years")
jobaddress1=request("jobaddress1")
jobaddress2=request("jobaddress2")
salary=request("salary")
job=request("job")
inresume=request("inresume")
Set rs=server.CreateObject("adodb.recordset")
sql="insert into in_user(name,idcard,sex,byear,bmonth,bday,hukou,juzhu,phone,oicq,website,address,postcode,major, major1,college,degree,language1,level1,language2,level2,years,jobaddress1,jobaddress2,salary,job,inresume)
value('"&amp;("name")&amp;"',
'"&amp; ("idcard")&amp;"','"&amp; ("sex")&amp;"','"&amp;("byear")&amp;"','"&amp; ("bmonth")&amp;"','"&amp;("bday")&amp;"','"&amp;("hukou")&amp;"',
'"&amp;("juzhu")&amp;"',"&amp;("phone")&amp;"','"&amp;("oicq")&amp;"','"&amp;("website")&amp;"','"&amp;("address")&amp;"',
'"&amp;("postcode")&amp;"','"&amp;("major")&amp;"','"&amp;("major1")&amp;"','"&amp;("college")&amp;"','"&amp;("degree")&amp;"',
'"&amp;("language1")&amp;"','"&amp;("level1")&amp;"','"&amp;("language2")&amp;"','"&amp;"level2")&amp;"','"&amp;("years")&amp;"',
'"&amp;("jobaddress1")&amp;"','"&amp;"jobaddress2")&amp;"','"&amp;("salary")&amp;"','"&amp;("job")&amp;"',
'"&amp;("inresume")&amp;"')where id="&amp;clng(session("id"))
rs.open sql,conn,1,1
rs.close
response.write "<script language=JavaScript>" &amp; chr(13) &amp; "alert('详细资料已完善！');"&amp;"window.location.href = 'in_center.asp'"&amp;" </script>"
%>[/color]
[color=FF0000]错误类型：
Microsoft VBScript 编译器错误 (0x800A0409)
未结束的字符串常量
/招聘网/members/in_handle1.asp, line 33, column 308
sql="insert into in_user(name,idcard,sex,byear,bmonth,bday,hukou,juzhu,phone,oicq,website,address,postcode,major,major1,college,degree,language1,level1,language2,level2,years,jobaddress1,jobaddress',salary,job,inresume) value('"&("name")&"','"& ("idcard")&"','"& ("sex")&"','"&("byear")&"','"& ("bmonth")&"',
-------------------------------------------------[/color]
看了半天也不知道是怎么一回事．．．郁闷啊．．．[em10][em10][em10]
