home *** CD-ROM | disk | FTP | other *** search
/ 202.53.64.216 / 202.53.64.216.tar / 202.53.64.216 / janahitha / AdsHoardingsTypeList.asp < prev    next >
Text File  |  2004-11-26  |  2KB  |  61 lines
  1. <!-- #include file="AdsOpenConn.asp" -->
  2. <%
  3.     TblHeadBGColor="#DDF0DF"
  4.     TblHeadFGColor="#000000"
  5.     TblBGColor="#ffffff"
  6.     TblFGColor="#005599"
  7. %>
  8. <html>
  9.     <head>
  10.         <title> Janahitha Ads - Welcome </title>
  11.         <meta name="author" content="Jagadish,Gopi">
  12.     </head>
  13.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  14.         <!-- #include file="AdsTop.asp" --> 
  15.         <center>
  16.         <table width=100% cellpadding=0 cellspacing=0 border=0 height=100%>
  17.         <tr>
  18.             <td width=150 align=center valign=top bgcolor="#FFFFFF">
  19.                 <!-- #include file="AdsLeft.asp" -->
  20.             </td>
  21.             <td width=630 align=center valign=top bgcolor="#ffffff">
  22.                 <br> 
  23.                 <!-- <b> <font face="verdana" color="#566336"> Types Of Hoardings</font> </b> <br> <br>-->
  24.                 <img src="AdsImages/Hoarding-Types.gif"> <br> <br>
  25.                 
  26.                 <table cellspacing=0 cellpadding=2 border=0 width=500>
  27. <%
  28.     set rs = server.createobject("adodb.recordset")
  29.     rs.open "select *from HoardingTypeMaster where HoardingTypeStatus=yes", con
  30.     sno = 0
  31.     while not rs.eof
  32.         sno = sno + 1
  33. %>
  34.                 <tr>
  35.                     <td>
  36.                         <font face="ms sans serif" size=2>
  37.                         <%=sno%>  
  38.                         <a href="AdsHoardingsList.asp?htypeid=<%=rs("HoardingTypeId")%>&list=ns"><font color="<%=TblFGColor%>"><%=rs("HoardingTypeName")%></font></a> <br> <br>
  39.                     <!--    Material : <font color="<%=TblFGColor%>"> <%=rs("HoardingMaterial")%> </font>      
  40.                         Lighting Type : <font color="<%=TblFGColor%>"> <%=rs("Hoardinglightingtype")%> </font>                              
  41.                         Stand Type : <font color="<%=TblFGColor%>"> <%=rs("Hoardingstandtype")%> </font>      
  42. -->
  43.                         </font>
  44.                     </td>
  45.                 </tr>
  46. <%
  47.         rs.movenext
  48.     wend
  49.     rs.close
  50.     set rs = nothing
  51. %>
  52.                 </table>
  53.                 <br>
  54.             </td>
  55.         </tr>
  56.         </table>
  57.         </center>
  58.         <!-- #include file="AdsBottom.asp" -->
  59.     </body>
  60. </html>
  61. <!-- #include file="AdsCloseConn.asp" -->