asp和数据库的问题

来源:百度知道 编辑:UC知道 时间:2024/06/17 02:40:08
strsql="select * from NEWS where CATEID="" & cid & """
rs.open strsql, conn, 1, 1
do while not rs.eof
cnt=cnt+1
if cnt < 6 then
dim ndate
ndate=DateAdd("d",-3,date())
response.write"<tr><td width='50%'><a onclick='return newwin(this.href);' href='newsView.asp?id="+cstr(rs("cid"))+"'>"+rs("TITLE")
if rs("ATTPIC") then
response.write"(附图)"
end if
response.write "</a>"
if datediff("d",rs("POSTTIME"),ndate+time())<=0 then
response.write"<img src='pic/new.gif' alt='最新新闻!' border=0></td>"
end if
response.write"<td width='20%'>("+cstr(rs("POSTTIME"))+")</td></tr>"
end if
rs.movenext
loop
response.write"</table&g

strsql="select * from NEWS where CATEID="" & cid & """
cateid字段如果是数字的应该这样写
strsql="select * from NEWS where CATEID=""& cid
cateid字段如果是字符的应该这样写
strsql="select * from NEWS where CATEID='" & cid & "'"
然后输出一下response.write rs.recordcount