ADODB.Recordset 错误 '800a0bb9'

参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。

/Inventory/displayc.asp,行 29

Feedback

#1楼    回复  引用    

2008-07-01 21:44 by 1水落石出 [未注册用户]
求救各位高手帮我解决问题

#2楼    回复  引用    

2008-07-04 06:41 by ouyanglin1989 [未注册用户]
Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp,行242

ADODB.Recordset 错误 '800a0bb9'

参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。

/jlxx.asp,行17
全部原代码
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/web.asp" -->

<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("编号") <> "") Then
Recordset1__MMColParam = Request.QueryString("编号")
End If
%>

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection =MM_web_STRING
Recordset1.Source = "SELECT * FROM 用户表 WHERE 编号 = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()

Recordset1_numRows = 0
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<table align="center" border="1">
<tr>
<td align="left" width="50%">编号</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("编号").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">用户名</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("用户名").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">密码</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("密码").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">电子邮件</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("电子邮件").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">是否愿意</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("是否愿意").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">附言</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("附言").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">知道本站</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("知道本站").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">注册时间</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("注册时间").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">ip</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("ip").Value)%></td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>



标题  
姓名  
主页
Email (博主才能看到) 
验证码 *  看不清,换一张 [登录][注册]
内容(请不要发表任何与政治相关的内容)  
  登录  使用高级评论  新用户注册  返回页首  恢复上次提交      
"五向定位"职业成长路线公开课(上海、南京、大连)
Google站内搜索


相关链接:
 

Copyright © kaixin110

Visit VisitCHN.com - China news, weather, business, travel, language courses