<%
' *** Edit Operations: declare variables
Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd
Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId
Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i
dim connstr
dim MM_WZ_STRING
set MM_WZ_STRING=server.CreateObject("adodb.connection")
connstr="DBQ="+server.mappath("wz.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
MM_WZ_STRING.Open connstr
%>
<%
If (CStr(Request("MM_delete")) <> "" And CStr(Request("MM_recordId")) <> "") Then
MM_editQuery = "delete from addlink where username='" & Request("MM_recordId") & "'"
response.Write MM_editQuery
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_WZ_STRING
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
If (MM_editRedirectUrl<>"")Then
MM_editRedirectUrl="manage.asp"
Response.Redirect("manage.asp")
Response.end
End if
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_WZ_STRING
Recordset1.Source = "SELECT * FROM addlink"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 15
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
编号 |
网站名称 |
网址 |
邮件信箱 |
网站内容简介 |
时间 |
点击次数 |
|
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<%=(Recordset1.Fields.Item("ID").value)%> |
<%=(Recordset1.Fields.Item("username").value)%> |
<%=(Recordset1.Fields.Item("HomePage").value)%> |
<%=(Recordset1.Fields.Item("Email").value)%> |
<%=(Recordset1.Fields.Item("Note").value)%> |
<%=(Recordset1.Fields.Item("Time").value)%> |
<%=(Recordset1.Fields.Item("Hits").value)%> |
|
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>