又不行了,是不是因为我用了分页的缘故?
<%@codepage=936%>
<%option explicit%>
<%
if Request.cookies("adname")="" then
Response.Redirect "index.htm"
end if
Dim conn,rs,myself,page,i,ipage
%>
<%
Set conn=Server.createobject("Adodb.connection")
conn.open "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Server.MapPath("db/myfriend.mdb")
Set rs=Server.createobject("Adodb.Recordset")
rs.open "GoodFriend",conn,1,3
If rs is Nothing Then
Response.write "Á¬½Óʧ°Ü"
Response.end
End If
Myself=Request.ServerVariables("Path_Info")
%>
ÎÒµÄÅóÓÑÃÇ <%
rs.pagesize=10
page=Clng(Request("page"))
If page<1 Then page=1
If page>rs.pagecount Then page=rs.Pagecount
showpage rs,page
%>
<%sub showpage(rs,page)
Response.write "
" & "ÎÒµÄÅóÓÑÃÇ"
Response.write ""
Response.write ""
For i=0 to rs.fields.count-1
Response.write "" & rs(i).name & " | "
Next
Response.write "
"
rs.Absolutepage=page
For ipage=1 to rs.pagesize
Response.write ""
For i=0 to rs.fields.count-1
Response.write "" & rs(i) & " | "
Next
Response.write "
"
rs.movenext
If rs.eof Then Exit For
Next
Response.write "
"
end sub
%>
New Document <%
name=Request("deluser")
if (name<>"") then
Set conn=Server.createobject("Adodb.connection")
conn.open "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Server.MapPath("db/myfriend.mdb")
Set rs=Server.createobject("Adodb.Recordset")
rs.filter="ÐÕÃû='" & name & "'"
if rs.eof then
response.write "ûÓÐÕÒµ½ÕâÌõ¼Ç¼:" & name
rs.filter=""
else
rs.delete
response.write "¼º¾É¾³ý"
rs.filter=""
end if
end if
%>