我现用的代码这样的: <% set rsb=server.createobject("adodb.recordset") sql="select * from guestbook where party_id=" & party_id & " order by ID desc" rsb.open sql,conn,3,2 %>
<% if publink="" then %> <bgsound src="sound/msg.wav" loop="-1"> <% end if %>
<%=rsb("publink")%></font></td> <td width="19%" height="21"><font color="#0000FF"><%=rsb("pubtime")%></font> <% rsb.Close Set rsb = Noting %> </td> </tr> <% End if If Not rs.Eof Then rs.movenext Next %>