home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
202.53.64.216
/
202.53.64.216.tar
/
202.53.64.216
/
janahitha
/
AdsHoardingsTypeListPrev.asp
< prev
next >
Wrap
Text File
|
2004-11-26
|
3KB
|
64 lines
<!-- #include file="AdsOpenConn.asp" -->
<%
TblHeadBGColor="#DDF0DF"
TblHeadFGColor="#000000"
TblBGColor="#ffffff"
TblFGColor="#000000"
%>
<html>
<head>
<title> Janahitha Ads - Welcome </title>
<meta name="author" content="Jagadish,Gopi">
</head>
<body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
<!-- #include file="AdsTop.asp" -->
<center>
<table width=100% cellpadding=0 cellspacing=0 border=0 height=100%>
<tr>
<td width=150 align=center valign=top bgcolor="#FFFFFF">
<!-- #include file="AdsLeft.asp" -->
</td>
<td width=630 align=center valign=top bgcolor="#ffffff">
<br> <b> <font face="verdana" color="#566336"> Types Of Hoardings</font> </b> <br> <br>
<table cellpadding=0 cellspacing=0 border=0>
<tr><td bgcolor="#47AF59">
<table cellpadding=1 cellspacing=1 border=0 width=570>
<tr>
<th bgcolor="<%=TblHeadBGColor%>"> <font face=verdana size=2 color="<%=TblHeadFGColor%>"> SNo </font> </th>
<th bgcolor="<%=TblHeadBGColor%>"> <font face=verdana size=2 color="<%=TblHeadFGColor%>"> Hoarding Type </font> </th>
<th bgcolor="<%=TblHeadBGColor%>"> <font face=verdana size=2 color="<%=TblHeadFGColor%>"> Width X Height </font> </th>
<th bgcolor="<%=TblHeadBGColor%>"> <font face=verdana size=2 color="<%=TblHeadFGColor%>"> Material </font> </th>
<th bgcolor="<%=TblHeadBGColor%>"> <font face=verdana size=2 color="<%=TblHeadFGColor%>"> Rent </font> </th>
</tr>
<%
set rs = server.createobject("adodb.recordset")
rs.open "select *from HoardingTypeMaster where HoardingTypeStatus=1", con
sno = 0
while not rs.eof
sno = sno + 1
%>
<tr>
<td bgcolor="<%=TblBGColor%>" align=right> <font face="ms sans serif" size=2 color="<%=TblFGColor%>"> <%=sno%> </font> </td>
<td bgcolor="<%=TblBGColor%>"> <a href="AdsHoardingsList.asp?htypeid=<%=rs("HoardingTypeId")%>&list=ns"><font face="ms sans serif" size=2 color="<%=TblFGColor%>"><%=rs("HoardingTypeName")%></font></a> </td>
<td bgcolor="<%=TblBGColor%>" align=center> <font face="ms sans serif" size=2 color="<%=TblFGColor%>"> <%=rs("HoardingWidth")%> X <%=rs("HoardingHeight")%> </font> </td>
<td bgcolor="<%=TblBGColor%>" align=center> <font face="ms sans serif" size=2 color="<%=TblFGColor%>"> <%=rs("HoardingMaterial")%> </font> </td>
<td bgcolor="<%=TblBGColor%>" align=right> <font face="ms sans serif" size=2 color="<%=TblFGColor%>"> <%=formatnumber(rs("HoardingRentalPrice"),2)%> </font> </td>
</tr>
<%
rs.movenext
wend
rs.close
set rs = nothing
%>
</table>
</td> </tr>
</table>
<br>
</td>
</tr>
</table>
</center>
<!-- #include file="AdsBottom.asp" -->
</body>
</html>
<!-- #include file="AdsCloseConn.asp" -->