|
PO BOX 14 Postal Code 115 Madinat Sultan Qaboos, Sultanate of Oman Ph : 00968 596454 Fax : 00968 597089
|
|
Job Details
|
|
|
<%
set Cn = Server.CreateObject("ADODB.Connection")
Cn.Open "driver=SQL Server;server=216.122.236.5;uid=alamjad;pwd=INdNPcsm6qk;database=alamjad"
dim Mjobid
Mjobid = " "
Mjobid = request.querystring("mjobid")
SQL="Select uname,job_id,job_title,convert(char(15),date_sub,103) AS submitted,st_date,qual,duties,addinfo from subjob where job_id ='" & Mjobid & "'"
SQLC = "select company_name,cont_name,address1,address2,city,country from company where uname ="
SQLC = SQLC & "(select distinct uname from subjob where job_id = '" &Mjobid & "' )"
Set rs=cn.execute(SQL)
if not rs.EOF and NOT rs.BOF then
rs.movefirst
set rs2=cn.execute(sqlc)
madd = rs2("address1") &" " &rs2("address2")
madd2 = rs2("city") &" " &rs2("country")
else
response.write " " &"Job Id does not Exists " response.write " " &"vist us at " &"Career Section" end if 'EOF BOF Check %> Company Name |
<%=rs2("company_name")%> | ||
| Address | <%=madd%> <%=madd2%> | ||
| Contact Name | <%=rs2("cont_name")%> | ||
| Job ID | <%=rs("job_id")%> | ||
| Date Submitted | <%=rs("SUBMITTED")%> - DD/MM/YYYY | ||
| Job Title | <%=rs("job_title")%> | ||
| Job Start Date | <%=rs("st_date")%>- DD/MM/YYYY | ||
|
Job Description |
|||
|
|
|||
