把分类ID加进去一起判断该怎么写？谢谢各位帮忙解答一下
我想把分类ID加进去一起判断该怎么写？我的代码是这样：
'=================================================
'过程名：contextual_set
'作 用：显示作品上下个
'参 数：无
'=================================================
sub contextual_set()
set RelationArt = conn.execute("select top 1 soft_id,soft_name from soft where soft_id<"&request.querystring("soft_id")&" and passed=0 order by soft_time desc")
IF RelationArt.eof and relationArt.bof then
Response.Write "<font color=red>·上个作品：</font>已经没有了<BR> "
else
Response.Write "<font color=red>·上个作品：</font><a href=""showset.asp?soft_id=" & RelationArt(0) & """>" & relationArt(1) & "</a><BR>"
end if
Set RelationArt=Nothing
set RelationArt = conn.execute("select top 1 soft_id,soft_name from soft where soft_id>"&request.querystring("soft_id")&" and passed=0 order by soft_id")
IF RelationArt.eof and relationArt.bof Then
Response.Write "<font color=red>·下个作品：</font>已经没有了"
else
Response.Write "<font color=red>·下个作品：</font><a href=""showset.asp?soft_id=" & RelationArt(0) & """>" & relationArt(1) & "</a></td>"
end if
RelationArt.close
Set RelationArt=Nothing
end sub
谢谢各位帮忙解答一下，谢谢了
