28,391
社区成员
发帖
与我相关
我的任务
分享用dw mx自动生成的代码怎么会出错？
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/byxt.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_byxt_STRING
Recordset1.Source = "SELECT userid,username FROM user"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 2
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<table border="1">
<tr>
<td>userid</td>
<td>username</td>
</tr>
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<tr>
<td><%=(Recordset1.Fields.Item("userid").Value)%></td>
<td><%=(Recordset1.Fields.Item("username").Value)%></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
结果
序号 类别 作者
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp，行242
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象
/byx/TMP84q4qlzupj.asp，行36
<!--#include file="Connections/byxt.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_byxt_STRING
Recordset1.Source = "SELECT userid,username FROM user"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 2
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<table border="1">
<tr>
<td>userid</td>
<td>username</td>
</tr>
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<tr>
<td><%=(Recordset1.Fields.Item("userid").Value)%></td>
<td><%=(Recordset1.Fields.Item("username").Value)%></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
结果
序号 类别 作者
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp，行242
Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象
/byx/TMP84q4qlzupj.asp，行36
...全文
请发表友善的回复…
发表回复
云帆 2003-09-30
- 打赏
- 举报
别让它自动生成，页面设计可以用它，但是后台代码还是自己写的好
h2high 2003-09-30
- 打赏
- 举报
先不要去掉DW原有的<html> <head> <body> 等标记，要不然它会不知道代码放哪的。 ^_^
h2high 2003-09-30
- 打赏
- 举报
Recordset还没有用就Close了？
把
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
放到最后试试？
把
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
放到最后试试？
zjg791015 2003-09-30
- 打赏
- 举报
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
<%Wend%>
<%Wend%>
短短的 2003-09-30
- 打赏
- 举报
建议不要用这个,dw自动生成的代码没有几个人可以真正看懂,一旦出问题,后果就很麻烦,我以前也是用这个的.
