日期:2014-05-17  浏览次数:20753 次

asp的一个根据字段判断是否显示的问题,求高手帮忙
<%sql= "select   top   50   *   from   bar   where   show> =1   order   by   count   desc "
Set   rs=   Server.CreateObject( "ADODB.Recordset ")
rs.open   sql,conn,1,1
if   rs.eof   and   rs.bof   then%>
    <tr>
        <td   width= "99% "   height= "80 "   bgcolor= "#FFFFFF "   style= "font-size:   9pt;   line-height:   13pt "> <p   align= "center "> <font   color= "#800000 ">
暂时没有数据! </font> </td>
    </tr>
<%else
do   while   not   rs.eof%>
    <tr>
    <%for   i=1   to   5%>
        <td   width= "20% "   height=30   bgcolor= "#FFFFFF "   style= "font-size:   9pt;   line-height:   13pt ">
&nbsp; <a   class=style299   href= "go.asp?id= <%=rs( "id ")%> "   target= "_blank "   title= "当前积分   <%=rs( "count ")%>   点 "> <%=rs( "yytime ")%> </a> </td>
      <%rs.MoveNext()%>
      <%next%>
    </tr>
<%
title=title+1
if   title> =5   then   Exit   Do
loop
end   if%>

麻烦高手帮忙看一下这段代码,表bar中有名为number和number123的两个字段,如何写代码才能做到当number大于等于number1时,
这里   <a   class=style299   href= "go.asp?id= <%=rs( "id ")%> "   target= "_blank "   title= "积分   <%=rs( "count ")%>   点 "> <%=rs( "yytime ")%> </a> 的超链接地址不显示,只显示出 <%=rs( "yytime ")%>

请高手帮帮忙,谢谢

------解决方案--------------------
<%
if cdbl(number) <cdbl(number1) then
%>
<td width= "20% " height=30 bgcolor= "#FFFFFF " style= "font-size: 9pt; line-height: 13pt ">
&nbsp; <a class=style299 href= "go.asp?id= <%=rs( "id ")%> " target= "_blank " title= "当前积分 <%=rs( "count ")%> 点 "> <%=rs( "yytime ")%> </a> </td>
<%
else
%>
<td width= "20% " height=30 bgcolor= "#FFFFFF " style= "font-size: 9pt; line-height: 13pt ">
&nbsp <%=rs( "yytime ")%> </td>
<%
end if
%>