% nCount = "" strSql = "select count(popno) from tbPopup where activeYN='Y'" rs.open strSql,dbConn, 1 nCount = Cint(rs(0)) rs.Close if nCount > 0 then strSql = "select top 1 popno from tbPopup where activeYN='Y'" rs.open strSql,dbConn, 1 nPopno = Cint(rs(0)) rs.Close %>
<%end if%>
|
|||||||||||||||||||||||||||