……………………………………………………………………………………
<%
if Trim(Request.QueryString("action"))="del" then
ID = Trim(Request.QueryString("ID"))
set rs=server.createobject("adodb.recordset")
sql="select * from pay where ID ="&ID
rs.open sql,conn,1,3
rs.delete
rs.close
end if
%>
数据显示
……………………………………………………………………………………
<%
Lei="行业资讯" '设置显示信息类别
set rs=server.CreateObject("adodb.Recordset")
sql="Select top 20 * from News where Lei <> '"&Lei&"' order by ID desc"
rs.open sql,conn,1,1
if rs.eof then '判断数据库内有无信息,防止读取错误
%>
暂无信息!
<%
else
do while not rc.eof
%>
<%if len(rs("Title")) > 10 then Response.write left(rs("Title"),10)&"..." else Response.write rs("Title") end if%>
<%
'循环显示数据
rc.movenext
loop
rc.close
set rc=nothing
end if%>