<%
Dim news__MMColParam
news__MMColParam = "新闻动态"
If (Request("MM_EmptyValue") <> "") Then
news__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim news
Dim news_cmd
Dim news_numRows
Set news_cmd = Server.CreateObject ("ADODB.Command")
news_cmd.ActiveConnection = MM_conn_STRING
news_cmd.CommandText = "SELECT * FROM news WHERE newsty = ? ORDER BY newstime DESC"
news_cmd.Prepared = true
news_cmd.Parameters.Append news_cmd.CreateParameter("param1", 200, 1, 255, news__MMColParam) ' adVarChar
Set news = news_cmd.Execute
news_numRows = 0
%>
<%
Dim xuexi
Dim xuexi_cmd
Dim xuexi_numRows
Set xuexi_cmd = Server.CreateObject ("ADODB.Command")
xuexi_cmd.ActiveConnection = MM_conn_STRING
xuexi_cmd.CommandText = "SELECT * FROM news WHERE newsty ='视光医学' ORDER BY newstime DESC"
xuexi_cmd.Prepared = true
Set xuexi = xuexi_cmd.Execute
xuexi_numRows = 0
%>
<%
Dim gx__MMColParam
gx__MMColParam = "光学配镜"
If (Request("MM_EmptyValue") <> "") Then
gx__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim gx
Dim gx_cmd
Dim gx_numRows
Set gx_cmd = Server.CreateObject ("ADODB.Command")
gx_cmd.ActiveConnection = MM_conn_STRING
gx_cmd.CommandText = "SELECT * FROM news WHERE newsty = ?"
gx_cmd.Prepared = true
gx_cmd.Parameters.Append gx_cmd.CreateParameter("param1", 200, 1, 255, gx__MMColParam) ' adVarChar
Set gx = gx_cmd.Execute
gx_numRows = 0
%>
<%
Dim yx__MMColParam
yx__MMColParam = "营销管理"
If (Request("MM_EmptyValue") <> "") Then
yx__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim yx
Dim yx_cmd
Dim yx_numRows
Set yx_cmd = Server.CreateObject ("ADODB.Command")
yx_cmd.ActiveConnection = MM_conn_STRING
yx_cmd.CommandText = "SELECT * FROM news WHERE newsty = ?"
yx_cmd.Prepared = true
yx_cmd.Parameters.Append yx_cmd.CreateParameter("param1", 200, 1, 255, yx__MMColParam) ' adVarChar
Set yx = yx_cmd.Execute
yx_numRows = 0
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = 2
Repeat2__index = 0
xuexi_numRows = xuexi_numRows + Repeat2__numRows
%>
<%
Dim Repeat3__numRows
Dim Repeat3__index
Repeat3__numRows = 2
Repeat3__index = 0
gx_numRows = gx_numRows + Repeat3__numRows
%>
<%
Dim Repeat4__numRows
Dim Repeat4__index
Repeat4__numRows = 3
Repeat4__index = 0
yx_numRows = yx_numRows + Repeat4__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
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 7
Repeat1__index = 0
news_numRows = news_numRows + Repeat1__numRows
%>
天津万里路视光职业培训学校
