暗黑破坏神2钥匙:变量或者类型不正确
来源:百度文库 编辑:高考问答 时间:2024/04/30 08:53:39
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
ADODB.Recordset 错误 '800a0bb9'
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
/at/8-3-2.asp,行9
请问这个错误何因?谢谢
代码:
<html>
<body>
<h2>客户</h2>
<table width=80% boder=1>
<%
dim objcommand,rs,strconn
strconn="Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=H:\wwwroot\8\northwind.mdb"
set objcommand=server.createobject("adodb.command")
objcommand.activeconnection=strconn
objcommand.commandtext="select 编号,姓名,学号" &_
"from test"&_
"where 年龄='22'"
objcommand.commandtype=adcmdtext
set rs=objcommand.execute
set objcommand=nothing
response.write"<tr>"
dim objfield
for each objfield in rs.fields
response.write"<th>" &objfield.name
next
response.write"</tr><tr>"
do while not rs.eof
for each objfield in rs.fields
response.write "<td align=center>" &objfileld.value&"</td>"
next
response.write"</tr>"
rs.movenext
loop
response.write"</table>"
rs.close
set rs=nothing
%>
</center>
</body>
</html>
谢谢
SELECT 后仅设一个字段依然有冲突
objcommand.commandtype=adcmdtext
这句话去掉,就可以搞定了
缺少 'End'
/iisHelp/common/500-100.asp,行242
ADODB.Recordset 错误 '800a0bb9'
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
/at/8-3-2.asp,行9
请问这个错误何因?谢谢
代码:
<html>
<body>
<h2>客户</h2>
<table width=80% boder=1>
<%
dim objcommand,rs,strconn
strconn="Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=H:\wwwroot\8\northwind.mdb"
set objcommand=server.createobject("adodb.command")
objcommand.activeconnection=strconn
objcommand.commandtext="select 编号,姓名,学号" &_
"from test"&_
"where 年龄='22'"
objcommand.commandtype=adcmdtext
set rs=objcommand.execute
set objcommand=nothing
response.write"<tr>"
dim objfield
for each objfield in rs.fields
response.write"<th>" &objfield.name
next
response.write"</tr><tr>"
do while not rs.eof
for each objfield in rs.fields
response.write "<td align=center>" &objfileld.value&"</td>"
next
response.write"</tr>"
rs.movenext
loop
response.write"</table>"
rs.close
set rs=nothing
%>
</center>
</body>
</html>
谢谢
SELECT 后仅设一个字段依然有冲突
objcommand.commandtype=adcmdtext
这句话去掉,就可以搞定了
objfileld包含3个字段
一个objfileld.value不能表示出来的