Я сгенерил Frontpage Database Interface Wizard простую форму для TimeSheets.
Все работает, НО после нажатия кнопки ОК появляется Form Confirmation со всеми переданными данными.
Пожалуйста подскажите как убрать эти повторные данные и получить Form Confirmation
как надпись "Thank you for submitting information".
Заранее благодарен.
Саша




<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear

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("timesheets8_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "Results", 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(112)
Dim arFormDBFields0(112)
Dim arFormValues0(112)

arFormFields0(0) = "Week"
arFormDBFields0(0) = "Week"
arFormValues0(0) = Request("Week")
arFormFields0(1) = "Project2"
arFormDBFields0(1) = "Project2"
arFormValues0(1) = Request("Project2")
arFormFields0(2) = "Project1"
arFormDBFields0(2) = "Project1"
arFormValues0(2) = Request("Project1")
arFormFields0(3) = "Employee"
arFormDBFields0(3) = "Employee"
arFormValues0(3) = Request("Employee")
arFormFields0(4) = "Project3"
arFormDBFields0(4) = "Project3"
arFormValues0(4) = Request("Project3")
arFormFields0(5) = "Project4"
arFormDBFields0(5) = "Project4"
arFormValues0(5) = Request("Project4")
arFormFields0(6) = "Project5"
arFormDBFields0(6) = "Project5"
arFormValues0(6) = Request("Project5")
arFormFields0(7) = "Project6"
arFormDBFields0(7) = "Project6"
arFormValues0(7) = Request("Project6")
arFormFields0(8) = "Project7"
arFormDBFields0(8) = "Project7"
arFormValues0(8) = Request("Project7")
arFormFields0(9) = "Project8"
arFormDBFields0(9) = "Project8"
arFormValues0(9) = Request("Project8")
arFormFields0(10) = "Project9"
arFormDBFields0(10) = "Project9"
arFormValues0(10) = Request("Project9")
arFormFields0(11) = "Project10"
arFormDBFields0(11) = "Project10"
arFormValues0(11) = Request("Project10")
arFormFields0(12) = "Role1"
arFormDBFields0(12) = "Role1"
arFormValues0(12) = Request("Role1")
arFormFields0(13) = "Role2"
arFormDBFields0(13) = "Role2"
arFormValues0(13) = Request("Role2")
arFormFields0(14) = "Role3"
arFormDBFields0(14) = "Role3"
arFormValues0(14) = Request("Role3")
arFormFields0(15) = "Role4"
arFormDBFields0(15) = "Role4"
arFormValues0(15) = Request("Role4")
arFormFields0(16) = "Role5"
arFormDBFields0(16) = "Role5"
arFormValues0(16) = Request("Role5")
arFormFields0(17) = "Role6"
arFormDBFields0(17) = "Role6"
arFormValues0(17) = Request("Role6")
arFormFields0(18) = "Role7"
arFormDBFields0(18) = "Role7"
arFormValues0(18) = Request("Role7")
arFormFields0(19) = "Role8"
arFormDBFields0(19) = "Role8"
arFormValues0(19) = Request("Role8")
arFormFields0(20) = "Role9"
arFormDBFields0(20) = "Role9"
arFormValues0(20) = Request("Role9")
arFormFields0(21) = "Role10"
arFormDBFields0(21) = "Role10"
arFormValues0(21) = Request("Role10")
arFormFields0(22) = "Work1"
arFormDBFields0(22) = "Work1"
arFormValues0(22) = Request("Work1")
arFormFields0(23) = "Work2"
arFormDBFields0(23) = "Work2"
arFormValues0(23) = Request("Work2")
arFormFields0(24) = "Work3"
arFormDBFields0(24) = "Work3"
arFormValues0(24) = Request("Work3")
arFormFields0(25) = "Work4"
arFormDBFields0(25) = "Work4"
arFormValues0(25) = Request("Work4")
arFormFields0(26) = "Work5"
arFormDBFields0(26) = "Work5"
arFormValues0(26) = Request("Work5")
arFormFields0(27) = "Work6"
arFormDBFields0(27) = "Work6"
arFormValues0(27) = Request("Work6")
arFormFields0(28) = "Work7"
arFormDBFields0(28) = "Work7"
arFormValues0(28) = Request("Work7")
arFormFields0(29) = "Work8"
arFormDBFields0(29) = "Work8"
arFormValues0(29) = Request("Work8")
arFormFields0(30) = "Work9"
arFormDBFields0(30) = "Work9"
arFormValues0(30) = Request("Work9")
arFormFields0(31) = "Work10"
arFormDBFields0(31) = "Work10"
arFormValues0(31) = Request("Work10")
arFormFields0(32) = "Detail1"
arFormDBFields0(32) = "Detail1"
arFormValues0(32) = Request("Detail1")
arFormFields0(33) = "Detail2"
arFormDBFields0(33) = "Detail2"
arFormValues0(33) = Request("Detail2")
arFormFields0(34) = "Detail3"
arFormDBFields0(34) = "Detail3"
arFormValues0(34) = Request("Detail3")
arFormFields0(35) = "Detail4"
arFormDBFields0(35) = "Detail4"
arFormValues0(35) = Request("Detail4")
arFormFields0(36) = "Detail5"
arFormDBFields0(36) = "Detail5"
arFormValues0(36) = Request("Detail5")
arFormFields0(37) = "Detail6"
arFormDBFields0(37) = "Detail6"
arFormValues0(37) = Request("Detail6")
arFormFields0(38) = "Detail7"
arFormDBFields0(38) = "Detail7"
arFormValues0(38) = Request("Detail7")
arFormFields0(39) = "Detail8"
arFormDBFields0(39) = "Detail8"
arFormValues0(39) = Request("Detail8")
arFormFields0(40) = "Detail9"
arFormDBFields0(40) = "Detail9"
arFormValues0(40) = Request("Detail9")
arFormFields0(41) = "Detail10"
arFormDBFields0(41) = "Detail10"
arFormValues0(41) = Request("Detail10")
arFormFields0(42) = "Time11"
arFormDBFields0(42) = "Time11"
arFormValues0(42) = Request("Time11")
arFormFields0(43) = "Time12"
arFormDBFields0(43) = "Time12"
arFormValues0(43) = Request("Time12")
arFormFields0(44) = "Time13"
arFormDBFields0(44) = "Time13"
arFormValues0(44) = Request("Time13")
arFormFields0(45) = "Time14"
arFormDBFields0(45) = "Time14"
arFormValues0(45) = Request("Time14")
arFormFields0(46) = "Time15"
arFormDBFields0(46) = "Time15"
arFormValues0(46) = Request("Time15")
arFormFields0(47) = "Time16"
arFormDBFields0(47) = "Time16"
arFormValues0(47) = Request("Time16")
arFormFields0(48) = "Time17"
arFormDBFields0(48) = "Time17"
arFormValues0(48) = Request("Time17")
arFormFields0(49) = "Time18"
arFormDBFields0(49) = "Time18"
arFormValues0(49) = Request("Time18")
arFormFields0(50) = "Time19"
arFormDBFields0(50) = "Time19"
arFormValues0(50) = Request("Time19")
arFormFields0(51) = "Time110"
arFormDBFields0(51) = "Time110"
arFormValues0(51) = Request("Time110")
arFormFields0(52) = "Time21"
arFormDBFields0(52) = "Time21"
arFormValues0(52) = Request("Time21")
arFormFields0(53) = "Time22"
arFormDBFields0(53) = "Time22"
arFormValues0(53) = Request("Time22")
arFormFields0(54) = "Time23"
arFormDBFields0(54) = "Time23"
arFormValues0(54) = Request("Time23")
arFormFields0(55) = "Time24"
arFormDBFields0(55) = "Time24"
arFormValues0(55) = Request("Time24")
arFormFields0(56) = "Time25"
arFormDBFields0(56) = "Time25"
arFormValues0(56) = Request("Time25")
arFormFields0(57) = "Time26"
arFormDBFields0(57) = "Time26"
arFormValues0(57) = Request("Time26")
arFormFields0(58) = "Time27"
arFormDBFields0(58) = "Time27"
arFormValues0(58) = Request("Time27")
arFormFields0(59) = "Time28"
arFormDBFields0(59) = "Time28"
arFormValues0(59) = Request("Time28")
arFormFields0(60) = "Time29"
arFormDBFields0(60) = "Time29"
arFormValues0(60) = Request("Time29")
arFormFields0(61) = "Time210"
arFormDBFields0(61) = "Time210"
arFormValues0(61) = Request("Time210")
arFormFields0(62) = "Time31"
arFormDBFields0(62) = "Time31"
arFormValues0(62) = Request("Time31")
arFormFields0(63) = "Time32"
arFormDBFields0(63) = "Time32"
arFormValues0(63) = Request("Time32")
arFormFields0(64) = "Time33"
arFormDBFields0(64) = "Time33"
arFormValues0(64) = Request("Time33")
arFormFields0(65) = "Time34"
arFormDBFields0(65) = "Time34"
arFormValues0(65) = Request("Time34")
arFormFields0(66) = "Time35"
arFormDBFields0(66) = "Time35"
arFormValues0(66) = Request("Time35")
arFormFields0(67) = "Time36"
arFormDBFields0(67) = "Time36"
arFormValues0(67) = Request("Time36")
arFormFields0(68) = "Time37"
arFormDBFields0(68) = "Time37"
arFormValues0(68) = Request("Time37")
arFormFields0(69) = "Time38"
arFormDBFields0(69) = "Time38"
arFormValues0(69) = Request("Time38")
arFormFields0(70) = "Time39"
arFormDBFields0(70) = "Time39"
arFormValues0(70) = Request("Time39")
arFormFields0(71) = "Time310"
arFormDBFields0(71) = "Time310"
arFormValues0(71) = Request("Time310")
arFormFields0(72) = "Time41"
arFormDBFields0(72) = "Time41"
arFormValues0(72) = Request("Time41")
arFormFields0(73) = "Time42"
arFormDBFields0(73) = "Time42"
arFormValues0(73) = Request("Time42")
arFormFields0(74) = "Time43"
arFormDBFields0(74) = "Time43"
arFormValues0(74) = Request("Time43")
arFormFields0(75) = "Time44"
arFormDBFields0(75) = "Time44"
arFormValues0(75) = Request("Time44")
arFormFields0(76) = "Time45"
arFormDBFields0(76) = "Time45"
arFormValues0(76) = Request("Time45")
arFormFields0(77) = "Time46"
arFormDBFields0(77) = "Time46"
arFormValues0(77) = Request("Time46")
arFormFields0(78) = "Time47"
arFormDBFields0(78) = "Time47"
arFormValues0(78) = Request("Time47")
arFormFields0(79) = "Time48"
arFormDBFields0(79) = "Time48"
arFormValues0(79) = Request("Time48")
arFormFields0(80) = "Time49"
arFormDBFields0(80) = "Time49"
arFormValues0(80) = Request("Time49")
arFormFields0(81) = "Time410"
arFormDBFields0(81) = "Time410"
arFormValues0(81) = Request("Time410")
arFormFields0(82) = "Time51"
arFormDBFields0(82) = "Time51"
arFormValues0(82) = Request("Time51")
arFormFields0(83) = "Time52"
arFormDBFields0(83) = "Time52"
arFormValues0(83) = Request("Time52")
arFormFields0(84) = "Time53"
arFormDBFields0(84) = "Time53"
arFormValues0(84) = Request("Time53")
arFormFields0(85) = "Time54"
arFormDBFields0(85) = "Time54"
arFormValues0(85) = Request("Time54")
arFormFields0(86) = "Time55"
arFormDBFields0(86) = "Time55"
arFormValues0(86) = Request("Time55")
arFormFields0(87) = "Time56"
arFormDBFields0(87) = "Time56"
arFormValues0(87) = Request("Time56")
arFormFields0(88) = "Time57"
arFormDBFields0(88) = "Time57"
arFormValues0(88) = Request("Time57")
arFormFields0(89) = "Time58"
arFormDBFields0(89) = "Time58"
arFormValues0(89) = Request("Time58")
arFormFields0(90) = "Time59"
arFormDBFields0(90) = "Time59"
arFormValues0(90) = Request("Time59")
arFormFields0(91) = "Time510"
arFormDBFields0(91) = "Time510"
arFormValues0(91) = Request("Time510")
arFormFields0(92) = "Time61"
arFormDBFields0(92) = "Time61"
arFormValues0(92) = Request("Time61")
arFormFields0(93) = "Time62"
arFormDBFields0(93) = "Time62"
arFormValues0(93) = Request("Time62")
arFormFields0(94) = "Time63"
arFormDBFields0(94) = "Time63"
arFormValues0(94) = Request("Time63")
arFormFields0(95) = "Time64"
arFormDBFields0(95) = "Time64"
arFormValues0(95) = Request("Time64")
arFormFields0(96) = "Time65"
arFormDBFields0(96) = "Time65"
arFormValues0(96) = Request("Time65")
arFormFields0(97) = "Time66"
arFormDBFields0(97) = "Time66"
arFormValues0(97) = Request("Time66")
arFormFields0(98) = "Time67"
arFormDBFields0(98) = "Time67"
arFormValues0(98) = Request("Time67")
arFormFields0(99) = "Time68"
arFormDBFields0(99) = "Time68"
arFormValues0(99) = Request("Time68")
arFormFields0(100) = "Time69"
arFormDBFields0(100) = "Time69"
arFormValues0(100) = Request("Time69")
arFormFields0(101) = "Time610"
arFormDBFields0(101) = "Time610"
arFormValues0(101) = Request("Time610")
arFormFields0(102) = "Time71"
arFormDBFields0(102) = "Time71"
arFormValues0(102) = Request("Time71")
arFormFields0(103) = "Time72"
arFormDBFields0(103) = "Time72"
arFormValues0(103) = Request("Time72")
arFormFields0(104) = "Time74"
arFormDBFields0(104) = "Time74"
arFormValues0(104) = Request("Time74")
arFormFields0(105) = "Time73"
arFormDBFields0(105) = "Time73"
arFormValues0(105) = Request("Time73")
arFormFields0(106) = "Time75"
arFormDBFields0(106) = "Time75"
arFormValues0(106) = Request("Time75")
arFormFields0(107) = "Time76"
arFormDBFields0(107) = "Time76"
arFormValues0(107) = Request("Time76")
arFormFields0(108) = "Time77"
arFormDBFields0(108) = "Time77"
arFormValues0(108) = Request("Time77")
arFormFields0(109) = "Time78"
arFormDBFields0(109) = "Time78"
arFormValues0(109) = Request("Time78")
arFormFields0(110) = "Time79"
arFormDBFields0(110) = "Time79"
arFormValues0(110) = Request("Time79")
arFormFields0(111) = "Time710"
arFormDBFields0(111) = "Time710"
arFormValues0(111) = Request("Time710")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"

fp_rs.Close
fp_conn.Close

FP_FormConfirmationFromArrays "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"submission_form.asp",_
"Return to the form.",_
arFormDBFields0,_
arFormValues0

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<% Response.Buffer = True %>

Не совсем всё понял, но может тебе потом сделать просто на другую страницу Response.Redirect где ты там и на пишешь Thank you for submitting information