%
'On error resume next
con.Open ConnectionString
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs1=Server.CreateObject("ADODB.Recordset")
con.begintrans
rs.Open "select * from jobseeker where mailid='" & session("uname") & "' and status=0",Con,1,3
'jobseeker number genration
olddate=Rs("date1")
jsno=rs("membertype") & right("0" & request("cmbQualification"),2) & request("cmbSubject") & request("cmbExp")
x=left(rs("jobseekerno"),5)
if jsno<>x then
Str = "update jobseeker set status=1 where jobseekerno='" & rs("jobseekerno") & "'"
con.execute Str
querystr="select count(*) from jobseeker where membertype=" & rs("membertype") & " and hqualification=" & request("cmbQualification") & " and subjects=" & request("cmbSubject") & " and experience=" & request("cmbExp")
'response.write querystr
'response.end
rs1.Open querystr,Con,1,3
jsno = jsno & Right("000" & rs1(0)+1, 4)
StrSql = "insert into jobseeker (date1, jobseekerno, mailid, [password], [name], sex, martial, nationality, dob, address1, address2, city, state, country, phoneno, hqualification, univcollege, marks, subjects, others, experience, companyname, [position], expectedsal, placeofwork, areaofwork, otherinfo, blkstat, status,paid) values('"
StrSql = strSql & olddate & "', '"
StrSql = strSql & jsno & "', '"
StrSql = strSql & request("txtMailid") & "', '"
StrSql = strSql & request("txtPassword") & "', '"
StrSql = strSql & request("txtName") & "', '"
StrSql = strSql & request("sex") & "', '"
StrSql = strSql & request("martial") & "', '"
StrSql = strSql & request("txtNationality") & "','"
StrSql = strSql & request("txtDob") & "', '"
StrSql = strSql & request("txtAddr1") & "', '"
StrSql = strSql & request("txtAddr2") & "', '"
StrSql = strSql & request("txtCity") & "', '"
StrSql = strSql & request("txtState") & "', '"
StrSql = strSql & request("cmbCountry") & "', '"
StrSql = strSql & request("txtPhone") & "', "
StrSql = strSql & request("cmbQualification") & ", '"
StrSql = strSql & request("txtUniv") & "', '"
StrSql = strSql & request("txtmark") & "', "
StrSql = strSql & request("cmbSubject") & ", '"
StrSql = strSql & request("others") & "', "
StrSql = strSql & request("cmbExp") & ", '"
StrSql = strSql & request("txtConame") & "', '"
StrSql = strSql & request("txtPosition") & "', '"
StrSql = strSql & request("txtExpsal") & "', '"
StrSql = strSql & request("txtPlace") & "', '"
StrSql = strSql & request("txtArea") & "', '"
otherinf=request("otherinfo")
StrSql = strSql & replace(otherinf,"'","sat(1)") & "', "
StrSql = strSql & 0 & ", "
StrSql = strSql & 0 & ", "
StrSql = strSql & rs("paid") & ")"
'response.write StrSql
'response.end
con.execute StrSql
else
jsno=rs("jobseekerno")
dob=request("month") & "/" & request("day") & "/" & request("year")
StrSql = "update jobseeker set jobseekerno='"
StrSql = strSql & jsno & "', [password]='"
StrSql = strSql & request("txtPassword") & "', martial='"
StrSql = strSql & request("martial") & "', address1='"
StrSql = strSql & request("txtAddr1") & "', address2='"
StrSql = strSql & request("txtAddr2") & "', city='"
StrSql = strSql & request("txtCity") & "', state='"
StrSql = strSql & request("txtState") & "', country='"
StrSql = strSql & request("cmbCountry") & "', phoneno='"
StrSql = strSql & request("txtPhone") & "', hqualification="
StrSql = strSql & request("cmbQualification") & ", univcollege='"
StrSql = strSql & request("txtUniv") & "', marks='"
StrSql = strSql & request("txtmark") & "', subjects="
StrSql = strSql & request("cmbSubject") & ", others='"
StrSql = strSql & request("others") & "', experience="
StrSql = strSql & request("cmbExp") & ", companyname='"
StrSql = strSql & request("txtConame") & "', [position]='"
StrSql = strSql & request("txtPosition") & "', expectedsal='"
StrSql = strSql & request("txtExpsal") & "', placeofwork='"
StrSql = strSql & request("txtPlace") & "', areaofwork='"
StrSql = strSql & request("txtArea") & "', otherinfo='"
otherinf=request("otherinfo")
StrSql = strSql & replace(otherinf,"'","sat(1)") & "' where mailid='" & session("uname") & "' and status=0"
con.execute StrSql
rs.close
end if
con.committrans
con.close
response.redirect "login.asp?ru=1&jn=" & jsno
%>
<%
x=Request.QueryString("jobcat")
%>
Allbiotechjobs.com bringing together job seekers and job providers in Biotechnology
|
|
<%if request.querystring("err")="1" then%>
|
You have already
submitted your resume
|
<%end if%>
|
|
|
|
|