<% set objRS = Server.CreateObject("ADODB.Recordset") 'sql="SELECT * from tender where date() <= ldate order by ldate " sql="select SNO,ByBranch,ByDeptt,Subject,GivenTo,Format(GivenDate ,'dd/MM/yyyy') as GivenDate,Cost,TenderRefNo,TenderType,Format(TenderPubDate,'dd/MM/yyyy') as TenderPubDate,NoOfBidsRcvd,TenderType,Format(DateOfCompletion,'dd/MM/yyyy') as DateOfCompletion,AddresOfGivenTo from tenderAward where SNO="&sno&"" objRS.open sql, objConn,3,1,1 %>

Organisation Name	BIS/<%=Server.HTMLEncode(objRS.Fields("ByBranch").Value)%>/<%=Server.HTMLEncode(objRS.Fields("ByDeptt").Value)%>
Tender Ref. No.	<%=Server.HTMLEncode(objRS.Fields("TenderRefNo").Value)%>
Tender Description	<%=Server.HTMLEncode(objRS.Fields("Subject").Value)%>
Tender Type	<%=Server.HTMLEncode(objRS.Fields("TenderType").Value)%>
Tender Published Date	<%=Server.HTMLEncode(objRS.Fields("TenderPubDate").Value)%>
Number of bids received	<%=Server.HTMLEncode(objRS.Fields("NoOfBidsRcvd").Value)%>
Name of the selected bidder(s)	<%=Server.HTMLEncode(objRS.Fields("GivenTo").Value)%>
Address of the selected bidder(s)	<%=Server.HTMLEncode(objRS.Fields("AddresOfGivenTo").Value)%>
Contract Date	<%=Server.HTMLEncode(objRS.Fields("GivenDate").Value)%>
Contract Value	INR <%=Server.HTMLEncode(objRS.Fields("Cost").Value)%>
Date of Completion/Completion Period in Days	<%=Server.HTMLEncode(objRS.Fields("DateOfCompletion").Value)%>