把分类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

谢谢各位帮忙解答一下，谢谢了