% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next strErrorUrl = "" If Request.ServerVariables("REQUEST_METHOD") = "POST" Then If Request.Form("VTI-GROUP") = "0" Then Err.Clear Set fp_conn = Server.CreateObject("ADODB.Connection") FP_DumpError strErrorUrl, "Cannot create connection" Set fp_rs = Server.CreateObject("ADODB.Recordset") FP_DumpError strErrorUrl, "Cannot create record set" fp_conn.Open Application("ntwebsurvey2_ConnectionString") FP_DumpError strErrorUrl, "Cannot open database" fp_rs.Open "ntwebsurvey_table", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable FP_DumpError strErrorUrl, "Cannot open record set" fp_rs.AddNew FP_DumpError strErrorUrl, "Cannot add new record set to the database" Dim arFormFields0(111) Dim arFormDBFields0(111) Dim arFormValues0(111) arFormFields0(0) = "Q1a_other" arFormDBFields0(0) = "Q1a_other" arFormValues0(0) = Request("Q1a_other") arFormFields0(1) = "Q3_nt_age" arFormDBFields0(1) = "Q3_nt_age" arFormValues0(1) = Request("Q3_nt_age") arFormFields0(2) = "Q9_role" arFormDBFields0(2) = "Q9_role" arFormValues0(2) = Request("Q9_role") arFormFields0(3) = "Q11b_birdwatching" arFormDBFields0(3) = "Q11b_birdwatching" arFormValues0(3) = Request("Q11b_birdwatching") arFormFields0(4) = "Q11l_harvestfest" arFormDBFields0(4) = "Q11l_harvestfest" arFormValues0(4) = Request("Q11l_harvestfest") arFormFields0(5) = "Q14_webage" arFormDBFields0(5) = "Q14_webage" arFormValues0(5) = Request("Q14_webage") arFormFields0(6) = "Q27_problemsupdate" arFormDBFields0(6) = "Q27_problemsupdate" arFormValues0(6) = Request("Q27_problemsupdate") arFormFields0(7) = "Q31e_commimportant" arFormDBFields0(7) = "Q31e_commimportant" arFormValues0(7) = Request("Q31e_commimportant") arFormFields0(8) = "Q15_websurvey" arFormDBFields0(8) = "Q15_websurvey" arFormValues0(8) = Request("Q15_websurvey") arFormFields0(9) = "Q31c_commparticipate" arFormDBFields0(9) = "Q31c_commparticipate" arFormValues0(9) = Request("Q31c_commparticipate") arFormFields0(10) = "Q37_oftenwebpersonal" arFormDBFields0(10) = "Q37_oftenwebpersonal" arFormValues0(10) = Request("Q37_oftenwebpersonal") arFormFields0(11) = "Q51_comment" arFormDBFields0(11) = "Q51_comment" arFormValues0(11) = Request("Q51_comment") arFormFields0(12) = "Q6_customer" arFormDBFields0(12) = "Q6_customer" arFormValues0(12) = Request("Q6_customer") arFormFields0(13) = "Q18_webknowledge" arFormDBFields0(13) = "Q18_webknowledge" arFormValues0(13) = Request("Q18_webknowledge") arFormFields0(14) = "Q19a_other" arFormDBFields0(14) = "Q19a_other" arFormValues0(14) = Request("Q19a_other") arFormFields0(15) = "Q20a_time" arFormDBFields0(15) = "Q20a_time" arFormValues0(15) = Request("Q20a_time") arFormFields0(16) = "Q11e_education" arFormDBFields0(16) = "Q11e_education" arFormValues0(16) = Request("Q11e_education") arFormFields0(17) = "Q11f_elder_hostel" arFormDBFields0(17) = "Q11f_elder_hostel" arFormValues0(17) = Request("Q11f_elder_hostel") arFormFields0(18) = "Q11j_guiding" arFormDBFields0(18) = "Q11j_guiding" arFormValues0(18) = Request("Q11j_guiding") arFormFields0(19) = "Q11q_mountainbiking" arFormDBFields0(19) = "Q11q_mountainbiking" arFormValues0(19) = Request("Q11q_mountainbiking") arFormFields0(20) = "Q11t_selftour" arFormDBFields0(20) = "Q11t_selftour" arFormValues0(20) = Request("Q11t_selftour") arFormFields0(21) = "Q11w_other" arFormDBFields0(21) = "Q11w_other" arFormValues0(21) = Request("Q11w_other") arFormFields0(22) = "Q28_place" arFormDBFields0(22) = "Q28_place" arFormValues0(22) = Request("Q28_place") arFormFields0(23) = "Q30_createcomm" arFormDBFields0(23) = "Q30_createcomm" arFormValues0(23) = Request("Q30_createcomm") arFormFields0(24) = "Q31ca_howoften" arFormDBFields0(24) = "Q31ca_howoften" arFormValues0(24) = Request("Q31ca_howoften") arFormFields0(25) = "Q31db_othermeet" arFormDBFields0(25) = "Q31db_othermeet" arFormValues0(25) = Request("Q31db_othermeet") arFormFields0(26) = "Q33ba_phone" arFormDBFields0(26) = "Q33ba_phone" arFormValues0(26) = Request("Q33ba_phone") arFormFields0(27) = "Q48a_other" arFormDBFields0(27) = "Q48a_other" arFormValues0(27) = Request("Q48a_other") arFormFields0(28) = "Q2c_zip" arFormDBFields0(28) = "Q2c_zip" arFormValues0(28) = Request("Q2c_zip") arFormFields0(29) = "Q4d_other" arFormDBFields0(29) = "Q4d_other" arFormValues0(29) = Request("Q4d_other") arFormFields0(30) = "Q11g_family_reunion" arFormDBFields0(30) = "Q11g_family_reunion" arFormValues0(30) = Request("Q11g_family_reunion") arFormFields0(31) = "Q12_webpurpose" arFormDBFields0(31) = "Q12_webpurpose" arFormValues0(31) = Request("Q12_webpurpose") arFormFields0(32) = "Q13c_state" arFormDBFields0(32) = "Q13c_state" arFormValues0(32) = Request("Q13c_state") arFormFields0(33) = "Q31da_otherphone" arFormDBFields0(33) = "Q31da_otherphone" arFormValues0(33) = Request("Q31da_otherphone") arFormFields0(34) = "Q33_commoutside" arFormDBFields0(34) = "Q33_commoutside" arFormValues0(34) = Request("Q33_commoutside") arFormFields0(35) = "Q47_cost" arFormDBFields0(35) = "Q47_cost" arFormValues0(35) = Request("Q47_cost") arFormFields0(36) = "Q11c_boating" arFormDBFields0(36) = "Q11c_boating" arFormValues0(36) = Request("Q11c_boating") arFormFields0(37) = "Q11r_photography" arFormDBFields0(37) = "Q11r_photography" arFormValues0(37) = Request("Q11r_photography") arFormFields0(38) = "Q17b_webimportant" arFormDBFields0(38) = "Q17b_webimportant" arFormValues0(38) = Request("Q17b_webimportant") arFormFields0(39) = "Q24_helpgrow" arFormDBFields0(39) = "Q24_helpgrow" arFormValues0(39) = Request("Q24_helpgrow") arFormFields0(40) = "Q31b_commplace" arFormDBFields0(40) = "Q31b_commplace" arFormValues0(40) = Request("Q31b_commplace") arFormFields0(41) = "Q31ba_commwhere" arFormDBFields0(41) = "Q31ba_commwhere" arFormValues0(41) = Request("Q31ba_commwhere") arFormFields0(42) = "Q32e_commnotlike" arFormDBFields0(42) = "Q32_commnotlike" arFormValues0(42) = Request("Q32e_commnotlike") arFormFields0(43) = "Q36_webfornt" arFormDBFields0(43) = "Q36_webfornt" arFormValues0(43) = Request("Q36_webfornt") arFormFields0(44) = "Q38_oftenwebbus2" arFormDBFields0(44) = "Q38_oftenwebbus2" arFormValues0(44) = Request("Q38_oftenwebbus2") arFormFields0(45) = "Q10_income" arFormDBFields0(45) = "Q10_ income" arFormValues0(45) = Request("Q10_income") arFormFields0(46) = "Q11p_hunting" arFormDBFields0(46) = "Q11p_hunting" arFormValues0(46) = Request("Q11p_hunting") arFormFields0(47) = "Q19_whodevelop" arFormDBFields0(47) = "Q19_whodevelop" arFormValues0(47) = Request("Q19_whodevelop") arFormFields0(48) = "Q25_webcosteff" arFormDBFields0(48) = "Q25_webcosteff" arFormValues0(48) = Request("Q25_webcosteff") arFormFields0(49) = "Q26_vision" arFormDBFields0(49) = "Q26_vision" arFormValues0(49) = Request("Q26_vision") arFormFields0(50) = "Q31dc_formalmeet" arFormDBFields0(50) = "Q31dc_formalmeet" arFormValues0(50) = Request("Q31dc_formalmeet") arFormFields0(51) = "Q50_results" arFormDBFields0(51) = "Q50_results" arFormValues0(51) = Request("Q50_results") arFormFields0(52) = "Q4a_why" arFormDBFields0(52) = "Q4a_why" arFormValues0(52) = Request("Q4a_why") arFormFields0(53) = "Q11a_arrowhead" arFormDBFields0(53) = "Q11a_arrowhead" arFormValues0(53) = Request("Q11a_arrowhead") arFormFields0(54) = "Q11i_fishing" arFormDBFields0(54) = "Q11i_fishing" arFormValues0(54) = Request("Q11i_fishing") arFormFields0(55) = "Q16_bussurvey" arFormDBFields0(55) = "Q16_bussurvey" arFormValues0(55) = Request("Q16_bussurvey") arFormFields0(56) = "Q20_webresearch" arFormDBFields0(56) = "Q20_webresearch" arFormValues0(56) = Request("Q20_webresearch") arFormFields0(57) = "Q33bd_write" arFormDBFields0(57) = "Q33bd_write" arFormValues0(57) = Request("Q33bd_write") arFormFields0(58) = "Q42_security" arFormDBFields0(58) = "Q42_security" arFormValues0(58) = Request("Q42_security") arFormFields0(59) = "Q43_redesign" arFormDBFields0(59) = "Q43_redesign" arFormValues0(59) = Request("Q43_redesign") arFormFields0(60) = "Q4b" arFormDBFields0(60) = "Q4b" arFormValues0(60) = Request("Q4b") arFormFields0(61) = "Q6ab_other" arFormDBFields0(61) = "Q6ab_other" arFormValues0(61) = Request("Q6ab_other") arFormFields0(62) = "Q11o_historical" arFormDBFields0(62) = "Q11o_historical" arFormValues0(62) = Request("Q11o_historical") arFormFields0(63) = "Q31a_commname" arFormDBFields0(63) = "Q31a_commname" arFormValues0(63) = Request("Q31a_commname") arFormFields0(64) = "Q33be_other" arFormDBFields0(64) = "Q33be_other" arFormValues0(64) = Request("Q33be_other") arFormFields0(65) = "Q35_oftenwebbus" arFormDBFields0(65) = "Q35_oftenwebbus" arFormValues0(65) = Request("Q35_oftenwebbus") arFormFields0(66) = "Q41_webgood" arFormDBFields0(66) = "Q41_webgood" arFormValues0(66) = Request("Q41_webgood") arFormFields0(67) = "Q48_whomaintain" arFormDBFields0(67) = "Q48_whomaintain" arFormValues0(67) = Request("Q48_whomaintain") arFormFields0(68) = "Q2a_city" arFormDBFields0(68) = "Q2a_city" arFormValues0(68) = Request("Q2a_city") arFormFields0(69) = "Q4c" arFormDBFields0(69) = "Q4c" arFormValues0(69) = Request("Q4c") arFormFields0(70) = "Q17c_other" arFormDBFields0(70) = "Q17c_other" arFormValues0(70) = Request("Q17c_other") arFormFields0(71) = "Q31dd_write" arFormDBFields0(71) = "Q31dd_write" arFormValues0(71) = Request("Q31dd_write") arFormFields0(72) = "Q44_newfeatures" arFormDBFields0(72) = "Q44_newfeatures" arFormValues0(72) = Request("Q44_newfeatures") arFormFields0(73) = "Q46_continueonline" arFormDBFields0(73) = "Q46_continueonline" arFormValues0(73) = Request("Q46_continueonline") arFormFields0(74) = "Q2b_state" arFormDBFields0(74) = "Q2b_state" arFormValues0(74) = Request("Q2b_state") arFormFields0(75) = "Q13b_city" arFormDBFields0(75) = "Q13b_city" arFormValues0(75) = Request("Q13b_city") arFormFields0(76) = "Q1_nt_type" arFormDBFields0(76) = "Q1_nt_type" arFormValues0(76) = Request("Q1_nt_type") arFormFields0(77) = "Q11k_habitat" arFormDBFields0(77) = "Q11k_habitat" arFormValues0(77) = Request("Q11k_habitat") arFormFields0(78) = "Q11u_swimming" arFormDBFields0(78) = "Q11u_swimming" arFormValues0(78) = Request("Q11u_swimming") arFormFields0(79) = "Q12a_other" arFormDBFields0(79) = "Q12a_other" arFormValues0(79) = Request("Q12a_other") arFormFields0(80) = "Q13a_url" arFormDBFields0(80) = "Q13a_url" arFormValues0(80) = Request("Q13a_url") arFormFields0(81) = "Q22_satisfied" arFormDBFields0(81) = "Q22_satisfied" arFormValues0(81) = Request("Q22_satisfied") arFormFields0(82) = "Q45_expand" arFormDBFields0(82) = "Q45_expand" arFormValues0(82) = Request("Q45_expand") arFormFields0(83) = "Q11s_rockclimb" arFormDBFields0(83) = "Q11s_rockclimb" arFormValues0(83) = Request("Q11s_rockclimb") arFormFields0(84) = "Q33a_howoften" arFormDBFields0(84) = "Q33a_howoften" arFormValues0(84) = Request("Q33a_howoften") arFormFields0(85) = "Q40_expect" arFormDBFields0(85) = "Q40_expect" arFormValues0(85) = Request("Q40_expect") arFormFields0(86) = "Q17a_costeff" arFormDBFields0(86) = "Q17a_costeff" arFormValues0(86) = Request("Q17a_costeff") arFormFields0(87) = "Q23_fulfill" arFormDBFields0(87) = "Q23_fulfill" arFormValues0(87) = Request("Q23_fulfill") arFormFields0(88) = "Q31de_no" arFormDBFields0(88) = "Q31de_no" arFormValues0(88) = Request("Q31de_no") arFormFields0(89) = "Q33bc_formalmeet" arFormDBFields0(89) = "Q33bc_formalmeet" arFormValues0(89) = Request("Q33bc_formalmeet") arFormFields0(90) = "Q5_bplan" arFormDBFields0(90) = "Q5_bplan" arFormValues0(90) = Request("Q5_bplan") arFormFields0(91) = "Q8_size" arFormDBFields0(91) = "Q8_size" arFormValues0(91) = Request("Q8_size") arFormFields0(92) = "Q11h_work_experience" arFormDBFields0(92) = "Q11h_work_experience" arFormValues0(92) = Request("Q11h_work_experience") arFormFields0(93) = "Q11n_hiking" arFormDBFields0(93) = "Q11n_hiking" arFormValues0(93) = Request("Q11n_hiking") arFormFields0(94) = "Q13_webhost" arFormDBFields0(94) = "Q13_webhost" arFormValues0(94) = Request("Q13_webhost") arFormFields0(95) = "Q21_telldesign" arFormDBFields0(95) = "Q21_telldesign" arFormValues0(95) = Request("Q21_telldesign") arFormFields0(96) = "Q24a_futuregrow" arFormDBFields0(96) = "Q24a_futuregrow" arFormValues0(96) = Request("Q24a_futuregrow") arFormFields0(97) = "Q39_infouseful" arFormDBFields0(97) = "Q39_infouseful" arFormValues0(97) = Request("Q39_infouseful") arFormFields0(98) = "Q6a_how" arFormDBFields0(98) = "Q6a_how" arFormValues0(98) = Request("Q6a_how") arFormFields0(99) = "Q7_no_employees" arFormDBFields0(99) = "Q7_no_employees" arFormValues0(99) = Request("Q7_no_employees") arFormFields0(100) = "Q9a_other" arFormDBFields0(100) = "Q9a_other" arFormValues0(100) = Request("Q9a_other") arFormFields0(101) = "Q13d_zip" arFormDBFields0(101) = "Q13d_zip" arFormValues0(101) = Request("Q13d_zip") arFormFields0(102) = "Q33bb_meet" arFormDBFields0(102) = "Q33bb_meet" arFormValues0(102) = Request("Q33bb_meet") arFormFields0(103) = "Q11d_camping" arFormDBFields0(103) = "Q11d_camping" arFormValues0(103) = Request("Q11d_camping") arFormFields0(104) = "Q11m_hayrides" arFormDBFields0(104) = "Q11m_hayrides" arFormValues0(104) = Request("Q11m_hayrides") arFormFields0(105) = "Q11v_tubingraft" arFormDBFields0(105) = "Q11v_tubingraft" arFormValues0(105) = Request("Q11v_tubingraft") arFormFields0(106) = "Q17c_bestpromote" arFormDBFields0(106) = "Q17c_bestpromote" arFormValues0(106) = Request("Q17c_bestpromote") arFormFields0(107) = "Q29_placeimportant" arFormDBFields0(107) = "Q29_placeimportant" arFormValues0(107) = Request("Q29_placeimportant") arFormFields0(108) = "Q34_oftenemail" arFormDBFields0(108) = "Q34_oftenemail" arFormValues0(108) = Request("Q34_oftenemail") arFormFields0(109) = "Q35a_webcurious" arFormDBFields0(109) = "Q35a_webcurious" arFormValues0(109) = Request("Q35a_webcurious") arFormFields0(110) = "Q49_interview" arFormDBFields0(110) = "Q49_interview" arFormValues0(110) = Request("Q49_interview") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 If Request.ServerVariables("REMOTE_HOST") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name" End If If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type" End If FP_SaveFieldToDB fp_rs, Now, "Timestamp" If Request.ServerVariables("REMOTE_USER") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name" End If fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close Session("FP_SavedFields")=arFormFields0 Session("FP_SavedValues")=arFormValues0 Response.Redirect "thanks.asp" End If End If %>
APPENDIX A. ONLINE SURVEY INSTRUMENT