<%
if keyno<>"" then
sql="select * from miscell where state='1' and keyno="&keyno
else
sql="select * from miscell where state='1' and classcode='105' order by sortnum"
end if
rs.Open sql,cn,1,3
if not rs.EOF then
title=trim(rs("title"))
sortnum=rs("sortnum")
content=trim(rs("content"))
querycount=trim(rs("querycount"))
newsform=trim(rs("newsform"))
author=trim(rs("author"))
classcode=rs("classcode")
picflag=rs("picflag")
picflag2=rs("picflag2")
flag=rs("flag")
website=trim(rs("website"))
basclass=rs("basclass")
creadate=rs("creadate")
rs("querycount")=rs("querycount")+1
picalign=trim(rs("picalign"))
infocount=rs("infocount")
rs.Update
else
Response.End
end if
rs.Close
%>
| 来源:<%=newsform%> 编辑:<%=author%> 浏览<%=querycount%>次 |
|
|
<%
sqltext="select top 1 keyno,title from investigate where parentno=0 and flag='1' order by sortnum desc"
rs.Open sqltext,cn,1,1
if not rs.EOF then
parentno=rs(0)
title=trim(rs(1))
else
parentno=0
title="目前没有暂设置调查表"
end if
rs.Close
%>
<%if parentno=0 then%>
网上调查:<%=title%>
|
<%else%>
<%
sqltext="select keyno,title from investigate where parentno="&parentno&" order by sortnum "
rs.Open sqltext,cn,1,1
i=1
do while not rs.EOF
%>
<%
i=i+1
rs.MoveNext
loop
rs.Close
%>
|
| |
<%end if%>
|
|