欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

请教小弟我要实现从另一个页面传值过来根据这个值从数据库取得数据显示当前页,可以在当前页点击上一条记录和下一条记录应该怎么实现

更新时间: 2014-01-05 01:52:37 责任编辑: Author_N1

 

请问我要实现从另一个页面传值过来根据这个值从数据库取得数据显示当前页,可以在当前页点击上一条记录和下一条记录应该如何实现.
<%@LANGUAGE="VBSCRIPT"%>

<!--#include file="../Connections/conn.asp" -->
<%
Dim detail__MMColParam
detail__MMColParam = "1"
If (Request.QueryString("productcode") <> "") Then 
  detail__MMColParam = Request.QueryString("productcode")
End If
%>
<%
Dim detail
Dim detail_numRows

Set detail = Server.CreateObject("ADODB.Recordset")
detail.ActiveConnection = MM_conn_STRING
detail.Source = "SELECT * FROM Product WHERE productcode = '" + Replace(detail__MMColParam, "'", "''") + "'"
detail.CursorType = 0
detail.CursorLocation = 2
detail.LockType = 1
detail.Open()

detail_numRows = 0
%>
<%
Dim plist
Dim plist_numRows

Set plist = Server.CreateObject("ADODB.Recordset")
plist.ActiveConnection = MM_conn_STRING
plist.Source = "SELECT * FROM line"
plist.CursorType = 0
plist.CursorLocation = 2
plist.LockType = 1
plist.Open()

plist_numRows = 0
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index

Repeat2__numRows = -1
Repeat2__index = 0
plist_numRows = plist_numRows + Repeat2__numRows
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
plist_numRows = plist_numRows + Repeat1__numRows
%>


<%
Dim MM_paramName 
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth

Dim MM_removeList
Dim MM_item
Dim MM_nextItem

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
  MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If

MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
  MM_nextItem = "&" & MM_item & "="
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
  MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
  End If
Next

' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
  MM_nextItem = "&" & MM_item & "="
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
  MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
  End If
Next

' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then 
  MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
  MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
  MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
  If (firstItem <> "") Then
  MM_joinChar = "&"
  Else
  MM_joinChar = ""
  End If
End Function
%>
<script language="javascript" src="Tips.js"></script>
上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 01:52:37
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/2387/
本文WWW.DOC100.NET DOC100.NET版权所有。