Abee Registration Form

<%@ language="Vbscript"%> <% varfn = "" varln = "" varadd1 = "" varcity = "" varstate = "" varphone = "" varemail = "" varresumedetails = "" varposition = "" varjobclassification = "" varexperience = "" if request("submit") = "Submit" then fname= trim(request("fname")) lname= trim(request("lname")) add1 = replace(trim(request("add1")),",","") city = trim(request("city")) state = trim(request("state")) phone = trim(request("phone")) email = trim(request("email")) resumedetails =(request("resumedetails")) position = trim(replace(request("position"),",","")) jobclassification = trim(replace(request("jobclassification"),",","")) experience = trim(replace(request("experience"),",","")) set conn = server.createobject("ADODB.Connection") conn.Open "dsn=abeedatabase;uid=abee;pwd=abee2001info" sql = "insert into abeejoin(firstname,lastname,address,city,state,phone,email,resumedetails,position,jobclassification,experience)" & "values('"&fname&"','"&lname&"','"&add1&"','"&city&"','"&state&"','"&phone&"','"&email&"','"&resumedetails&"','"&position&"','"&jobclassification&"','"&experience&"')" 'sql = sql &"'" & trim(request("fname")) & "'" & "," 'sql = sql &"'" & trim(request("lname")) & "'" & "," 'sql = sql &"'" & trim(request("add1")) & "'" & "," 'sql = sql & "'" & trim(request("city")) & "'" & "," 'sql = sql & "'" & trim(request("state")) & "'" & "," 'sql = sql & "'" & trim(request("phone")) & "'" & "," 'sql = sql & "'" & trim(request("email")) & "'" & "," 'sql = sql & "'"&(request("resumedetails"))&"'" & "," 'sql = sql & "'" & trim(request("position")) & "')" conn.Execute "insert into abeejoin(firstname,lastname,address,city,state,phone,email,resumedetails,position,jobclassification,experience)" & "values('"&fname&"','"&lname&"','"&add1&"','"&city&"','"&state&"','"&phone&"','"&email&"','"&resumedetails&"','"&position&"','"&jobclassification&"','"&experience&"')" submitmsg = "Congrats!Thanks for the information" end if 'Response.Write(request("resumedetails")) %> Abee Registration Form

	That's how people at Abee Info describe the working environment. Abee offers excellent growth opportunities for people who are fully committed to their professional duties.
a

<%if errmsg="" then%> <%if submitmsg <> "" then%> <%else%> <%end if%>

<%=submitmsg%> Details Have been submitted!

JOIN ABEE FORM

<%else%>

<%=errmsg%>

<%end if%>

	First Name:	" onblur="fncase()">
	Last Name:	" onblur="lncase()">
	Address	">
	State
	City:	">
	Phone No:	">
	E-mail Address:	" onblur ="chkmail()">
	Experience:(No of Years)
	Please select the dept. you want to contact
	Resume Brief:

	Job Classification Interest(s): R
	Accounting & Financial Clerical Office Admin Education Engineering & Technical Industry & Skilled Trades Information Technology