MyCareer, MyFuture - Application Form

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% if request("submit") = "Submit" then student_name = request("name") icno = request("icno") phone1 = request("phone1") phone2 = request("phone2") gender = request("gender") age = request("age") marital = request("marital") race1 = request("race1") race2 = request("race2") paddress1 = request("paddress1") paddress2 = request("paddress2") ppostcode = request("ppostcode") pstate = request("pstate") caddress1 = request("caddress1") caddress2 = request("caddress2") cpostcode = request("cpostcode") cstate = request("cstate") email = request("email") dipfield = request("dipfield") dipinst = request("dipinst") dipyear = request("dipyear") dipcgpa = request("dipcgpa") degfield = request("degfield") deginst = request("deginst") degyear = request("degyear") degcgpa = request("degcgpa") masfield = request("masfield") masinst = request("masinst") masyear = request("masyear") mascgpa = request("mascgpa") Set db = Server.CreateObject("ADODB.Connection") conn = "Provider=SQLOLEDB;Data Source=202.190.203.133;Initial Catalog=mypartnerscommy_db;User ID=mypartnerscommy;Password=IDkGNkyD;" db.Open conn db.execute("insert into student_info (StdName,IC,Phone,Mobile,Gender,Age,Marital,Race,Race_Others,Add_Per_1,Add_Per_2,Add_Per_Postal,Add_Per_State,Add_Cor_1,Add_Cor_2,Add_Cor_Postal,Add_Cor_State,Email,DipField,DipIns,DipYear,DipCGPA,DegField,DegIns,DegYear,DegCGPA,MasterField,MasterIns,MasterYear,MasterCGPA,Regdate) "&_ "values ('" & student_name & "','" & icno & "','" & phone1 & "','" & phone2 & "','" & gender & "','" & age & "','" & marital & "','" & race1 & "','" & race2 & "','" & paddress1 & "','" & paddress2 & "','" & ppostcode & "','" & pstate & "','" & caddress1 & "','" & caddress2 & "','" & cpostcode & "','" & cstate & "','" & email & "','" & dipfield & "','" & dipinst & "','" & dipyear & "','" & dipcgpa & "','" & degfield & "','" & deginst & "','" & degyear & "','" & degcgpa & "','" & masfield & "','" & masinst & "','" & masyear & "','" & mascgpa & "',getdate())") db.close response.Redirect("success.asp") end if %> MyCareer, MyFuture - Application Form

APPLICATION FORM
"MYCAREER, MYFUTURE" PROGRAMME

A. PERSONAL INFORMATION
1) Applicant's Name
2) I/C Number (New)			3) Telephone Number
4) Mobile Number			5) Gender
6) Age			7) Marital Status
8) Race
Others
9) Permanent Address

Postcode
State
10) Correspondence Address

Postcode
State
11) Email

B. ACADEMIC INFORMATION
12) Courses Completed
a) Diploma
Field of Study
Institution
Year of Completion			CGPA
b) Bachelor Degree
Field of Study
Institution
Year of Completion			CGPA
c) Master Degree
Field of Study
Institution
Year of Completion			CGPA

C. DECLARATION OF APPLICATION
I hereby declare and confirm that all the information given are true, accurate and complete