主题:  dw如何赋值给变量

mxhmysuc

职务:普通成员
等级:1
金币:0.0
发贴:32
注册:2006/5/23 10:00:42
#12006/12/16 0:43:54
  想实现当点第一个按钮时给变量赋一个值,点第二个按钮时给变量赋另一个值,记录集根据变量不同形成不同的筛选值,筛选不同的记录。
  在定义记录集的筛选是选cookie,还是选阶段变量,还是选输入值?定义记录集时dw什么自动生成MMColParam变量?我在第一个按钮的onclick事件中给MMColParam一个值,在第二个个按钮的onclick事件中给MMColParam另一个值,什么实现不了?请高手指教!



mxhmysuc

职务:普通成员
等级:1
金币:0.0
发贴:32
注册:2006/5/23 10:00:42
#22006/12/16 0:45:05
自己做的代码如下:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn_hc.asp" -->
<%
Dim rs_t1__MMColParam
rs_t1__MMColParam = "1"
If (Session("lm") <> "") Then
rs_t1__MMColParam = Session("lm")
End If
%>
<%
Dim rs_t1
Dim rs_t1_numRows

Set rs_t1 = Server.CreateObject("ADODB.Recordset")
rs_t1.ActiveConnection = MM_conn_hc_STRING
rs_t1.Source = "SELECT bt, lm FROM tb_news WHERE lm = '" + Replace(rs_t1__MMColParam, "'", "''") + "'"
rs_t1.CursorType = 0
rs_t1.CursorLocation = 2
rs_t1.LockType = 1
rs_t1.Open()

rs_t1_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 width="632" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="115" height="33">&nbsp;</td>
<td width="145">&nbsp;</td>
<td width="52">&nbsp;</td>
<td width="145">&nbsp;</td>
<td width="56">&nbsp;</td>
<td width="119">&nbsp;</td>
</tr>
<tr>
<td height="31">&nbsp;</td>
<td valign="top"><img src="image/MENUL1.gif" width="145" height="20" onclick="MMColParam=分析" /></td>
<td>&nbsp;</td>
<td valign="top"><img src="image/MENUL2.gif" width="145" height="20" onclick="MMColParam=动态" /></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="19">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="128">&nbsp;</td>
<td colspan="4" valign="top"><%=(rs_t1.Fields.Item("bt").value)%></td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="79">&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</body>
</html>
<%
rs_t1.Close()
Set rs_t1 = Nothing
%>



mxhmysuc

职务:普通成员
等级:1
金币:0.0
发贴:32
注册:2006/5/23 10:00:42
#32006/12/16 0:47:12
出错信息:

ADODB.Field 错误 '800a0bcd'

BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。

/3.asp,行60

------------------------------------------------------------------------------------------------------------
行60即: <td colspan="4" valign="top"><%=(rs_t1.Fields.Item("bt").value)%></td>