asp读取access数据库主题

<%

ssql="select * from gb order by id desc "
set rs=server.CreateObject("adodb.recordset")
rs.open ssql,con,1,1
n=4

do while not rs.eof and n>0

n=n-1
id=rs("id")
title=rs("title")
response.Write("<a href='http://www.xxx.com/book/?id="&id&"'>"&title&"</a><br>"

rs.movenext
loop
%>


直接复制上试试,可能有的地方要该该

---

<%

ssql="select * from gb order by id desc "
set rs=server.CreateObject("adodb.recordset")
rs.open ssql,con,1,1
n=4

do while not rs.eof and n>0

n=n-1
id=rs("id")
title=rs("title")
response.Write("<a href='http://www.xxx.com/book/?id="&id&"'>"&title&"</a><br>"

rs.movenext
loop
%>


直接复制上试试,可能有的地方要该该

---

select top 4 * from gb order by id desc

---

set rs=conn.execute("SELECT top 4 * FROM gbinfo order by id desc")
if rs.eof or rs.bof then
response.write("还没有留言...")
else
do while not rs.eof
response.write(表中的数据写到这地方)
rs.movenext
loop
end if
rs.close:set rs=nothing

---

'读取留言板的最新的四个留言主题SQL语句写法为:
<%
...
set rs=conn.execute("SELECT * FROM gbinfo") '改为
set rs=conn.execute("SELECT top 4 * FROM gbinfo order by id desc") '使用top n选项可以限制返回的数据行数,top n说明返回n行
...
%>
'/////////////////////////////////////////////////////
'点击留言标题的时候链接到http://www.xxx.com/book/ 的写法为:
<a href=# onclick="javascript:window.open('http://www.xxx.com/book/ ?id=<%=rs("id")%>')">留言标题</a>

---

哇!分数挺高的...