<%set rs_report=server.createobject("adodb.recordset")
' rs_report.open "select TOP 10 id,name,price,publish_time,page_number from report where can_available = true order by id desc",conn_coal_sqlserver_database,1,1
'rs_report.open "select TOP 10 id,name,price,publish_time,page_number from report order by report_level desc,publish_time desc",conn_marketreport_sqlserver_database,1,1
rs_report.open "SELECT TOP 10 * FROM report WHERE (name LIKE '%可行性研究报告%') order by id desc",conn_marketreport_sqlserver_database,1,1
if rs_report.eof and rs_report.bof then %>
<%else %>
| 报告名称 |
价格 |
页码 |
报告基准时间 |
<%
back_ground=true
rs_report.movefirst
howmanyrecords=0
set testfile=server.createobject("scripting.filesystemobject")
do while not rs_report.eof and howmanyrecords<16
back_ground=not back_ground
file_name_and_address=server.mappath("../report_html/report_"&rs_report("id")&".html")
%>
<% if testfile.fileexists(file_name_and_address) then%> .html" target=_blank><% else%>" target=_blank> <% end if %>
<%
response.write rs_report("name")
%> |
<%=rs_report("price")%> |
<%=rs_report("page_number")%> |
<%=rs_report("publish_time")%> |
<%howmanyrecords=howmanyrecords+1
rs_report.movenext
loop
end if
rs_report.close
set rs_report = nothing
%>
|
|