<% CONST strConnString1 = "DSN=CSWL1;uid=;Pwd=;" ' strConnString1 = "DSN=CalsoftGroup;uid=;Pwd=;" DIM strTitle,strLocation,strExperience,strTechSkill,strDomineSkill,strDescription,strEducation,strExpertise,strExperienceTo DIM strPublish,strPreview,strJobCode strPreview = request.Form("hdPreview") 'response.write strPreview &"
" 'response.end if strPreview ="P" then strJobCode = "" strPublish = request.form("ckbPublish") strTitle = request.form("txt_JobTitle") strLocation = request.form("cbLocation") strExperience = request.form("txt_Experience") strExperienceTo = request.form("txt_ExperienceTo") strTechSkill = request.form("cbSelectedTechSkill") strDomineSkill = request.form("cbCategory") strDescription = request.form("txt_description") strEducation = request.form("txt_Education") strExpertise = request.form("txt_Expertise") else DIM strJobId strJobId = request.QueryString("jobid") DIM objConn SET objConn = server.CreateObject("ADODB.Connection") 'objConn.Open strConnString1 objConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=" & Server.MapPath(".") & "..\..\db\CalsoftGroup.mdb;" & _ "Uid=;" & _ "Pwd=;" DIM rsCurrentOpening,sqlCurrentOpening,strAreaofExpertise SET rsCurrentOpening = server.CreateObject("ADODB.RecordSet") sqlCurrentOpening = "select * from CurrentOpening_Master where Delete_CurrentOpening ='F' and job_id =" & strJobId if rsCurrentOpening.state =1 then rsCurrentOpening.Close rsCurrentOpening.open sqlCurrentOpening,objConn,3,3 strJobCode = rsCurrentOpening("Job_Code") strTitle = rsCurrentOpening("Job_title") strLocation = rsCurrentOpening("Location") strAreaofExpertise = rsCurrentOpening("Area_Of_Expertise") strExperience = rsCurrentOpening("Experience") strExperienceTo = rsCurrentOpening("ExperienceTo") strTechSkill = rsCurrentOpening("Skills") ' strDomineSkill = rsCurrentOpening("Job_Code") strDescription = rsCurrentOpening("Description") strEducation = rsCurrentOpening("Prefered_Education") ' strExpertise = rsCurrentOpening("Job_Code") end if %>
Overview Work @ Calsoft Labs Current Openings Jobs Portal - Career Site