%@ Language=VBScript %> <%option explicit%> <% dim rs dim sql dim foundErr dim ErrMsg dim folderID rem 变量 - 分页用 dim totalRec dim n ,i,j,RowCount dim currentpage foundErr=false ErrMsg="" set rs=server.createobject("adodb.recordset") folderid=trim(request("id")) if folderid="" then response.write "
没有指定要阅读新闻类别的编号
" elseif not isInteger(folderid) then response.write "新闻类别编号必须是整数
" else call listNewsFolder() end if %> <% set rs=nothing call conn_end() sub listNewsFolder() on error resume next 'sql="select newsFolder.id as folder_id,newsFolder.cname,newsFolder.name,newsFolder.lastupdated,newsFolder.total,news.id,news.time,news.title,news.source,news.isPicNews,news.hits,newstotalFolder.totalcname (from newsfolder left join news on newsfolder.id = news.folderid)inner join newstotalfolder on newsFolder.classid=newstotalFolder.id where newsFolder.id=" & folderid & " order by news.id desc" sql="select newsFolder.id as folder_id,newsFolder.cname,newsFolder.name,newsFolder.lastupdated,newsFolder.total,news.id,news.time,news.title,news.source,news.isPicNews,news.hits from newsfolder left join news on newsfolder.id = news.folderid where newsFolder.id=" & folderid & " order by news.id desc" 'Response.Write sql rs.open sql,conn,1,1 if err.number<>0 then foundErr=true ErrMsg="数据库操作失败:" & err.description & "
" err.celar else if rs.bof and rs.eof then foundErr=true ErrMsg="新闻类别没有找到!
" err.celar else %>|
| |||
|
|
||
|
|||||
|
法律学人
|
|||||||||||||||||||||||||||||||||||||||||
[关于我们] [社长致辞] [我们的媒体] [联络我们] [网上投稿] [广告服务]
中国检察日报社 web@jcrb.com.cn
版权所有 未经授权 严禁转载
Copyright 1999-2000,all rights reserved
" 'response.write "
"
if currentPage>1 then
response.write "前页 "
else
response.write "前页 "
end if
response.write currentpage & "/" & n & "页 "
if currentpage