<%@LANGUAGE="VBSCRIPT"%>
<html>
<head>
<title>News Board</title>
</head>
<body bgcolor="#E1F0FF">
<% a = (request.querystring("a"))
session("cmpid")=a
 %>
<h1 align="center"><span class="style1">e</span> Recruit </h1>
<table align="center" border="0">
<tr>
   <th bgcolor="AAC5F4">Title</th> 
</tr>

<% 
set con=Server.CreateObject("ADODB.Connection")
set res=Server.CreateObject("ADODB.recordset")
str = "DSN=erec;UID=sa;PWD=sa"
con.open str
if not a=0 then
sql="select company.name , uploads.path,uploads.title from uploads,company where uploads.id = company.id and company.id = " & a


set res=con.execute(sql)
do while not res.eof

%>
<tr><td><a href="<%Response.Write(res(1))%>"><%Response.Write(res(2))%></a></td></tr>
<%
res.movenext
loop
else
sql="select  uploads.path,uploads.title from uploads where uploads.id =" & a 

'sql="select * from uploads"
set res=con.execute(sql)
'response.Write(sql)
do while not res.eof

%>
<tr><td><a href="<%Response.Write(res(0))%>"><%Response.Write(res(1))%></a></td></tr>
<%
res.movenext
loop
end if

%>

</table>

<br>
<br>
<br>
<br>
<br>

<table border="0" align="center">
<tr><td><a href="adm_remove.asp">Remove Notice</a> </td>
</tr>
</table>
</body>
</html>
