<%
id=trim(Request.QueryString("id"))
if id <> "" then
set conn=server.CreateObject("ADODB.Connection")
conn.Open application("constr")
set rs=server.CreateObject("ADODB.Recordset")
rs.Open "select * from admin_news where news_id = " & id & " ",conn,3,2
if not rs.EOF then
%>
<html>

	<head>
		<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
		<title>Veejay Lakshmi Engineering Works Ltd., Coimbatore, India</title>
		<meta name="Description" content="Veejay Lakshmi is the largest manufacturer of Two-for-one Twister (TFO) and the only manufacturer of Automatic Cone Winders (ACW) in India">
		<meta name="keywords" content="tfo, two for one twister, textile twister manufacturer, two-for-one twister, spinning and weaving, knitting yarn, tfo spindles manufacturer, 100% cotton manufacturer, ring winder, ring doubler, textile indian, auto cone winder, veejay lakshmi, sushma multimedia">
		<meta name="revisit-after" content="15 days">
		<link href="../vj.css" rel="styleSheet" type="text/css">
	</head>

	<body background="../image/bg.gif" topmargin="0" marginheight="0" leftmargin="0" marginwidth="0">
		<div align="left">
			<table border="0" cellpadding="0" cellspacing="0" width="762">
				<tr height="25">
					<td height="25" colspan="3" valign="top" align="right"></td>
				</tr>
				<tr height="75">
					<td width="250" height="75"><img height="75" src="../image/h1.jpg" width="250"></td>
					<td width="250" height="75"><img height="75" src="../image/h2.jpg" width="250"></td>
					<td width="262" height="75"><img height="75" src="../image/h3.jpg" width="262"></td>
				</tr>
				<tr height="25">
					<td height="25" colspan="3">
						<center>
							<table border="0" cellpadding="0" cellspacing="0" width="757">
								<tr height="23">
									<td width="88" height="23" class="menu"><a title="Home" href="../index.html"><font color="white">Home</font></a></td>
									<td width="90" height="23" class="menu"><a title="Growth" href="growth.html"><font color="white">Growth</font></a></td>
									<td width="92" height="23" class="menu"><a title="Products" href="products.html"><font color="white">Products</font></a></td>
									<td width="132" height="23" class="menu"><a title="Infrastructure" href="infra.html"><font color="white">Infrastructure</font></a></td>
									<td width="92" height="23" class="menu"><a title="Sales Network" href="sales.html"><font color="white">Sales</font></a></td>
									<td width="90" height="23" class="menu"><a title="Sales Network" href="spares.html"><font color="white">Spares</font></a></td>
									<td width="92" height="23" class="menu"><a title="Financial Results" href="results.html"><font color="white">Investors</font></a></td>
									<td width="79" height="23" class="menu"><a title="Contact Us" href="contact.asp"><font color="white">Contact</font></a></td>
								</tr>
							</table>
						</center>
					</td>
				</tr>
			</table>
			<table border="0" cellpadding="0" cellspacing="0" width="762" bgcolor="white">
				<tr height="1">
					<td width="170" height="1" valign="top"></td>
					<td width="592" height="1" valign="top"></td>
				</tr>
				<tr height="20">
					<td width="170" valign="top" bgcolor="#f0f0f0" rowspan="10"></td>
					<td width="592" height="20" class="title">News at Veejay Lakshmi</td>
				</tr>
				<tr height="20">
					<td width="592" height="20" valign="top"></td>
				</tr>
				<%if rs("news_photo") <> "" then%>
				<tr height="20">
					<td width="592" height="20" valign="top">
						<p class="a"><img id="IMG1" src="<%=rs("news_photo")%>" ></p></td>
				</tr>
				<%end if%>
				<tr height="20">
					<td width="592" height="20" valign="top">
						<p class="newstitle"><b><%=rs("news_title")%></b></p></td>
				</tr>
				<tr height="20">
					<td width="592" height="20">
						<p class="a">Released on:<%=formatdatetime(rs("news_date"),vblongdate)%></p>
						<p class="a"><%=rs("news_content")%></p>                                                                                                                                                                         </td>
				</tr>
				<%end if%>
				<tr height="20">
					<td width="592" height="20"></td>
				</tr>
				<tr height="20">
					<td width="592" height="20" class="title">More News</td>
				</tr>
				<tr height="20">
					<td width="592" height="20"></td>
				</tr>
				<tr height="20">
					<td width="592" height="20">
						<ul>
						<%set rs1=server.CreateObject("ADODB.Recordset")
						'j=0
						rs1.Open "select * from admin_news order by news_date desc",conn,3,2
						if not rs1.EOF then
						j=0
						'rs1.MoveLast 
						do while not rs1.EOF
						
						if j=5 then
						exit do
						else
						
						a=formatdatetime(rs1("news_date"),1)
						b=split(a,",")
						c=b(1) &","& b(2)
						%>
							<li class="asmall"><a href="news-detail.asp?id=<%=rs1(0)%>"><%=rs1("news_title")%></a><i><%=c%></i>
							<%end if
							j=j+1
							rs1.MoveNext 
							loop
							end if
							%>
							</li>
						</ul>
						<p class="a"><a href="news-list.asp"><b>List All &gt;&gt;</b></a></p></td>
				</tr>
				<tr height="20">
					<td width="592" height="20"></td>
				</tr>
			</table>
			<table border="0" cellpadding="0" cellspacing="0" width="100%" height="60" bgcolor="navy">
				<tr height="20">
					<td width="762" height="20">
						<center>
							<span class="asmallwhite">© Veejay Lakshmi Engg. Works. Ltd.</span></center>
					</td>
					<td height="20"></td>
				</tr>
				<tr height="20" bgcolor="white">
					<td width="762" height="20">
						<center>
							<a href="http://www.sushmamm.com" target="_blank"><span class="footer">A Designer web site from Sushma Multimedia</span></a></center>
					</td>
					<td height="20"></td>
				</tr>
				<tr bgcolor="white">
					<td width="762"></td>
					<td></td>
				</tr>
			</table>
		</div>
	</body>

</html>
<%end if%>