%@ Language=VBScript %>
<%
'***************************************************************************
'AUTHOR : Sidney Wiredu and Robert Andrews
'FILE NAME : jobinfo.asp
'DATE OF CODE : 01/12/2007
'FUNCTIONALITY : The page that gives more details on specific job title.
'
'DATABASE : Jobs
'TABLE :
'STORED PROCEDURE: none
'CHANGED VERSION : DATE MODIFIED BY REASON
'
'******************************************************************************
%>
<%
''This lists the job details for each job from the database.
dim connection
Set connection= opendatabase()
dim recordset
Set recordset= server.createObject ("ADODB.recordset")
dim SQLstring
SQLstring= "Select JobName, JobID, JobPostDate, Security, JobType, JobWorkSite, JobExperienceRequirements, JobEducationRequirements, JobDuties from Job Where JobId= " & Request.QueryString("JobID")
RecordSet.Open SqlString, Connection
%>
Global TechPro Job Openings-<% =recordSet("JobName") %>
,as well as many other positions that are available as a full-time employee, intern, or as a contract position.">