📄 index_article_index.asp
字号:
<%
Dim RsArticleClass
Dim RsArticleClass_numRows
Set RsArticleClass = Server.CreateObject("ADODB.Recordset")
RsArticleClass.ActiveConnection = MM_connDB_STRING
RsArticleClass.Source = "SELECT * FROM tArticleClass ORDER BY fOrderID ASC"
RsArticleClass.CursorType = 0
RsArticleClass.CursorLocation = 2
RsArticleClass.LockType = 1
RsArticleClass.Open()
RsArticleClass_numRows = 0
%>
<%
'Dim Repeat1__numRows
'Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
RsArticleClass_numRows = RsArticleClass_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
%>
<TABLE cellSpacing=0 cellPadding=0 width="97%" border=0>
<tr>
<%
Dim num_tr
num_tr=0
%>
<%
While ((Repeat1__numRows <> 0) AND (NOT RsArticleClass.EOF))
%>
<TD vAlign=top><TABLE cellSpacing=0 cellPadding=0 width=273 border=0>
<TR>
<TD><IMG height=41 src="images/index1_1.gif" width=16></TD>
<TD width=230 background=images/index1_2.gif
height=42><div align="left"><IMG src="images/d5.gif"> <%=(RsArticleClass.Fields.Item("fClassName").Value)%></div></TD>
<TD width=30 background=images/index1_5.gif><IMG
height=41 src="images/index1_4.gif"
width=30></TD>
<TD width=40 background=images/index1_5.gif></TD>
<TD width=100 background=images/index1_5.gif></TD>
<TD width=14><IMG height=41
src="images/index1_7.gif" width=14></TD>
</TR>
<TR>
<TD background=images/index1_8.gif></TD>
<TD vAlign=top background=images/index1_9.gif colSpan=4>
<%
Dim RsArticleContent__MMColParam
RsArticleContent__MMColParam = RsArticleClass("fID_ArticleClass")
If (Request("MM_EmptyValue") <> "") Then
RsArticleContent__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim RsArticleContent
Dim RsArticleContent_numRows
Set RsArticleContent = Server.CreateObject("ADODB.Recordset")
RsArticleContent.ActiveConnection = MM_connDB_STRING
RsArticleContent.Source = "SELECT * FROM tArticleContent WHERE fID_ArticleClass = " + Replace(RsArticleContent__MMColParam, "'", "''") + " ORDER BY fID_ArticleContent DESC"
RsArticleContent.CursorType = 0
RsArticleContent.CursorLocation = 2
RsArticleContent.LockType = 1
RsArticleContent.Open()
RsArticleContent_numRows = 0
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = 10
Repeat2__index = 0
RsArticleContent_numRows = RsArticleContent_numRows + Repeat2__numRows
%>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TR>
<TD vAlign=bottom bgcolor="#F2F4FD"><div align="left">
<% While ((Repeat2__numRows <> 0) AND (NOT RsArticleContent.EOF)) %>
<IMG height=8 src="images/dd.gif" width=8 border=0> <A HREF="index_Article_Content.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "fID_ArticleContent=" & RsArticleContent.Fields.Item("fID_ArticleContent").Value %>" title="<%=(RsArticleContent.Fields.Item("fTitle").Value)%>
作者:<%=(RsArticleContent.Fields.Item("fAuthor").Value)%>" target="_blank">
<% If len(RsArticleContent.Fields.Item("fTitle").Value)<18 Then %>
<%=(RsArticleContent.Fields.Item("fTitle").Value)%>
<% Else %>
<%=mid((RsArticleContent.Fields.Item("fTitle").Value),1,17)%>…
<% End If %>
</A><BR>
<%
Repeat2__index=Repeat2__index+1
Repeat2__numRows=Repeat2__numRows-1
RsArticleContent.MoveNext()
Wend
%>
</div>
<div align=right><A HREF="index_Article_Class.asp?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "fID_ArticleClass=" & RsArticleClass("fID_ArticleClass") %>" target="_blank"><IMG height=17 src="images/more.gif" width=35 border=0></A> </div>
</TD>
</TR>
</TABLE>
<%
RsArticleContent.Close()
Set RsArticleContent = Nothing
%></TD>
<TD width=14 background=images/index1_10.gif height=170></TD>
</TR>
<TR>
<TD><IMG height=18 src="images/index1_11.gif" width=16></TD>
<TD width=250 background=images/index1_12.gif colSpan=4></TD>
<TD width=14><IMG height=18 src="images/index1_13.gif" width=14></TD>
</TR>
</TABLE></TD>
<%
num_tr=num_tr+1
If num_tr mod 2=0 Then
response.write "</tr><tr>"
End If
%>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
RsArticleClass.MoveNext()
Wend
%>
</TABLE>
<%
RsArticleClass.Close()
Set RsArticleClass = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -