28,409
社区成员




<%
strQuery = "SELECT * FROM t_url"
Set rs = adoDataConn.Execute(strQuery)
page = request("page")
rs.pagesize=20
if(page="") then
page=1
else
page=cint(page)
end if
response.Write(cstr(page))
rs.absolutepage = page
for i=1 to rs.pagesize %>
<ul>
<table width="515px" >
<td align="left"> <a href=<%=rs("content") %> target="_blank"><%=rs("title") %></a></td>
<td align="right"> <a href=../DataOperator.asp?delvalue=1&reback=Information/url.asp&sqlname=title&table=t_url&id=<%=rs("title")%> onclick="return ConfirmDel()">删除</a> </td>
</table>
</ul>
<% rs.movenext
if rs.eof then exit for
next
rs.close
%>
server.createobject("adodb.recordset") '加上这句
strQuery = "SELECT * FROM t_url"
Set rs = adoDataConn.Execute(strQuery)
strConnection = "driver={mysql odbc 3.51 driver};server=localhost;uid=root;pwd=421623;database=web"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection
strQuery = "SELECT * FROM t_url"
Set rs = server.createobject("adodb.recordset")
rs.open strQuery,adoDataConn,3,3
在网上查说什么EXECUTE不行,为什么我改成RS.OPEN也不行啊