xn=trim(request.form("xn"))
xq=trim(request.form("xq"))
bj=trim(request.form("bj"))
Set conn=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
conn.open"DSN=myconn;UID=sa;PWD=asp123"
sql="select bh,xm,km,cj,bj,xq,xn"
sql=sql+" from (SELECT student.bh ,student.xm ,student.bj,"
sql=sql+"score.km ,score.kt,score.zy,score.cy,score.sjys,score.sjys*0.3 as sjbl,"
sql=sql+"score.llys,score.llys*0.4 as llbl,"
sql=sql+"score.xq,score.kt+score.zy+score.cy+score.sjys*0.3 +score.llys*0.4 as cj,"
sql=sql+"score.bz,score.xq,score.xn into ##temp"
sql=sql+" FROM student,score WHERE student.xh=score.xh"
sql=sql+" and xn='"& xn &"' and xq='"& xq &"' and bj='"& bj &"') as a"sql=sql+" order by bh,km"
rs.open sql,conn,3,1
response.write(sql)错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'into' 附近有语法错误。
/repall2.asp, 第 20 行
麻烦高手给予查看
xq=trim(request.form("xq"))
bj=trim(request.form("bj"))
Set conn=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
conn.open"DSN=myconn;UID=sa;PWD=asp123"
sql="select bh,xm,km,cj,bj,xq,xn"
sql=sql+" from (SELECT student.bh ,student.xm ,student.bj,"
sql=sql+"score.km ,score.kt,score.zy,score.cy,score.sjys,score.sjys*0.3 as sjbl,"
sql=sql+"score.llys,score.llys*0.4 as llbl,"
sql=sql+"score.xq,score.kt+score.zy+score.cy+score.sjys*0.3 +score.llys*0.4 as cj,"
sql=sql+"score.bz,score.xq,score.xn into ##temp"
sql=sql+" FROM student,score WHERE student.xh=score.xh"
sql=sql+" and xn='"& xn &"' and xq='"& xq &"' and bj='"& bj &"') as a"sql=sql+" order by bh,km"
rs.open sql,conn,3,1
response.write(sql)错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'into' 附近有语法错误。
/repall2.asp, 第 20 行
麻烦高手给予查看
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货