%
action = request("action")
con.execute("update ds_companydefaults set cd_banner_click = cd_banner_click + 1")
%>
|
|
|
|
|
|
Home ยป Registration |
|
|
<%
on error resume next
if action = "" then
%>
Gammon in India is now in its 10th Decade. It is proposing to chronicle the major events in its past and wants to reach out to you. In order to enable it to do so, please provide the following information. |
|
<%
else
Name = filter_string(request("Name"))
email = filter_string(request("email"))
Mobile = filter_string(request("Mobile"))
Phone = filter_string(request("Phone"))
Address = replace(filter_string(request("Address")), chr(13), " ")
Association_Type = request("Association_Type")
Association_Type_Others = filter_string(request("Association_Type_Others"))
Dept_Name = filter_string(request("Dept_Name"))
tenure_from_mm = request("tenure_from_mm")
if tenure_from_mm <> "" then
tenure_from_mm_month = left(monthname(request("tenure_from_mm")),3) & " "
end if
Tenure_From = tenure_from_mm_month & request("tenure_from_yy")
tenure_to_mm = request("tenure_to_mm")
if tenure_to_mm <> "" then
tenure_to_mm_month = left(monthname(request("tenure_to_mm")),3) & " "
end if
Tenure_To = tenure_to_mm_month & request("tenure_to_yy")
Comments = replace(filter_string(request("Comments")), chr(13), " ")
ins_sql = "insert into ds_alumni_members "
ins_sql = ins_sql & "(mem_name, mem_email, mem_mobile, mem_phone, mem_address, mem_comments, mem_status, mem_reg_date, mem_dept, mem_emp_from, mem_emp_to, mem_emp_type, mem_emp_others)"
ins_sql = ins_sql & " values ('" & Name & "','" & email & "','" & Mobile & "','" & Phone & "','" & Address & "','" & Comments & "',1,'" & date() & "','" & Dept_Name & "','" & Tenure_From & "','" & Tenure_To & "','" & Association_Type & "','" & Association_Type_Others & "')"
con.execute(ins_sql)
Set rsmax = con.execute("select max(mem_id) as mem_id from ds_alumni_members where ltrim(rtrim(mem_email)) = '" & email & "'")
rec_mem_id = rsmax("mem_id")
total_associates = request("total_associates")
for i = 1 to total_associates
rec_name = replace(request("Refer_Name_"&i), "'", "''")
if trim(rec_name) <> "" then
rec_email = filter_string(request("Refer_Email_"&i))
rec_phone = filter_string(request("Refer_Phone_"&i))
rec_mobile = filter_string(request("Refer_Mobile_"&i))
rec_address = filter_string(request("Refer_Address_"&i))
con.execute("insert into ds_alumni_rec (rec_mem_id, rec_name, rec_email, rec_phone, rec_mobile, rec_address) values (" & rec_mem_id & ",'" & rec_name & "','" & rec_email & "','" & rec_phone & "','" & rec_mobile & "','" & rec_address & "')")
end if
Next
if con.errors.count = 0 then
%>
Thank you. Your co-operation is appreciated.
We shall get in touch with you shortly.
|
<%else%>
Sorry your form has not been
accepted.
Please ensure that the data you have entered is not
too large. |
<%end if%>
<%end if%>
|
|
|
|
|
|