<% ' 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 Session.LCID = 1033 Err.Clear strErrorUrl = "http://www.landsharksband.com" 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("Bands_Prices1_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(46) Dim arFormDBFields0(46) Dim arFormValues0(46) arFormFields0(0) = "ExtraMusicianTrumpet" arFormDBFields0(0) = "ExtraMusicianTrumpet" arFormValues0(0) = Request("ExtraMusicianTrumpet") arFormFields0(1) = "MusicTypeClassicRock" arFormDBFields0(1) = "MusicTypeClassicRock" arFormValues0(1) = Request("MusicTypeClassicRock") arFormFields0(2) = "MusicTypeNineties" arFormDBFields0(2) = "MusicTypeNineties" arFormValues0(2) = Request("MusicTypeNineties") arFormFields0(3) = "ExtraMusicianDancers" arFormDBFields0(3) = "ExtraMusicianDancers" arFormValues0(3) = Request("ExtraMusicianDancers") arFormFields0(4) = "StateDropDownButton" arFormDBFields0(4) = "StateDropDownButton" arFormValues0(4) = Request("StateDropDownButton") arFormFields0(5) = "Address2" arFormDBFields0(5) = "Address2" arFormValues0(5) = Request("Address2") arFormFields0(6) = "HowManyMusicians4" arFormDBFields0(6) = "HowManyMusicians4" arFormValues0(6) = Request("HowManyMusicians4") arFormFields0(7) = "MusicTypeBigBand" arFormDBFields0(7) = "MusicTypeBigBand" arFormValues0(7) = Request("MusicTypeBigBand") arFormFields0(8) = "HomePhone" arFormDBFields0(8) = "HomePhone" arFormValues0(8) = Request("HomePhone") arFormFields0(9) = "address" arFormDBFields0(9) = "address" arFormValues0(9) = Request("address") arFormFields0(10) = "ExtraMusicianFemaleVocals" arFormDBFields0(10) = "ExtraMusicianFemaleVocals" arFormValues0(10) = Request("ExtraMusicianFemaleVocals") arFormFields0(11) = "ExtraMusicianSaxophone" arFormDBFields0(11) = "ExtraMusicianSaxophone" arFormValues0(11) = Request("ExtraMusicianSaxophone") arFormFields0(12) = "MusicTypeCountry" arFormDBFields0(12) = "MusicTypeCountry" arFormValues0(12) = Request("MusicTypeCountry") arFormFields0(13) = "MusicTypeFifties" arFormDBFields0(13) = "MusicTypeFifties" arFormValues0(13) = Request("MusicTypeFifties") arFormFields0(14) = "ExtraMusicianCongas" arFormDBFields0(14) = "ExtraMusicianCongas" arFormValues0(14) = Request("ExtraMusicianCongas") arFormFields0(15) = "ExtraMusicianTrombone" arFormDBFields0(15) = "ExtraMusicianTrombone" arFormValues0(15) = Request("ExtraMusicianTrombone") arFormFields0(16) = "MusicTypeTropical" arFormDBFields0(16) = "MusicTypeTropical" arFormValues0(16) = Request("MusicTypeTropical") arFormFields0(17) = "Organization" arFormDBFields0(17) = "Organization" arFormValues0(17) = Request("Organization") arFormFields0(18) = "WhatTypeOfBand" arFormDBFields0(18) = "WhatTypeOfBand" arFormValues0(18) = Request("WhatTypeOfBand") arFormFields0(19) = "ExtraMusicianKeyboard" arFormDBFields0(19) = "ExtraMusicianKeyboard" arFormValues0(19) = Request("ExtraMusicianKeyboard") arFormFields0(20) = "MusicTypeEighties" arFormDBFields0(20) = "MusicTypeEighties" arFormValues0(20) = Request("MusicTypeEighties") arFormFields0(21) = "EventDate" arFormDBFields0(21) = "EventDate" arFormValues0(21) = Request("EventDate") arFormFields0(22) = "City" arFormDBFields0(22) = "City" arFormValues0(22) = Request("City") arFormFields0(23) = "MusicTypeSwing" arFormDBFields0(23) = "MusicTypeSwing" arFormValues0(23) = Request("MusicTypeSwing") arFormFields0(24) = "StartTimeDropDown" arFormDBFields0(24) = "StartTimeDropDown" arFormValues0(24) = Request("StartTimeDropDown") arFormFields0(25) = "MusicTypeToday" arFormDBFields0(25) = "MusicTypeToday" arFormValues0(25) = Request("MusicTypeToday") arFormFields0(26) = "Venue" arFormDBFields0(26) = "Venue" arFormValues0(26) = Request("Venue") arFormFields0(27) = "Name" arFormDBFields0(27) = "Name" arFormValues0(27) = Request("Name") arFormFields0(28) = "URL" arFormDBFields0(28) = "URL" arFormValues0(28) = Request("URL") arFormFields0(29) = "EmailAddress" arFormDBFields0(29) = "EmailAddress" arFormValues0(29) = Request("EmailAddress") arFormFields0(30) = "MusicTypeRock" arFormDBFields0(30) = "MusicTypeRock" arFormValues0(30) = Request("MusicTypeRock") arFormFields0(31) = "Zip" arFormDBFields0(31) = "Zip" arFormValues0(31) = Request("Zip") arFormFields0(32) = "MusicTypeTopForty" arFormDBFields0(32) = "MusicTypeTopForty" arFormValues0(32) = Request("MusicTypeTopForty") arFormFields0(33) = "MusicTypeReggae" arFormDBFields0(33) = "MusicTypeReggae" arFormValues0(33) = Request("MusicTypeReggae") arFormFields0(34) = "MusicTypeSixties" arFormDBFields0(34) = "MusicTypeSixties" arFormValues0(34) = Request("MusicTypeSixties") arFormFields0(35) = "MusicTypeSeventies" arFormDBFields0(35) = "MusicTypeSeventies" arFormValues0(35) = Request("MusicTypeSeventies") arFormFields0(36) = "ExtraMusiciansHornSection" arFormDBFields0(36) = "ExtraMusiciansHornSection" arFormValues0(36) = Request("ExtraMusiciansHornSection") arFormFields0(37) = "MusicTypeDance" arFormDBFields0(37) = "MusicTypeDance" arFormValues0(37) = Request("MusicTypeDance") arFormFields0(38) = "MusicTypeLatin" arFormDBFields0(38) = "MusicTypeLatin" arFormValues0(38) = Request("MusicTypeLatin") arFormFields0(39) = "FinishTime" arFormDBFields0(39) = "FinishTime" arFormValues0(39) = Request("FinishTime") arFormFields0(40) = "MusicTypeBeach" arFormDBFields0(40) = "MusicTypeBeach" arFormValues0(40) = Request("MusicTypeBeach") arFormFields0(41) = "MusicTypeVariety" arFormDBFields0(41) = "MusicTypeVariety" arFormValues0(41) = Request("MusicTypeVariety") arFormFields0(42) = "MusicTypeJazz" arFormDBFields0(42) = "MusicTypeJazz" arFormValues0(42) = Request("MusicTypeJazz") arFormFields0(43) = "State" arFormDBFields0(43) = "State" arFormValues0(43) = Request("State") arFormFields0(44) = "Comments" arFormDBFields0(44) = "Comments" arFormValues0(44) = Request("Comments") arFormFields0(45) = "WorkPhone" arFormDBFields0(45) = "WorkPhone" arFormValues0(45) = Request("WorkPhone") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close Session("FP_SavedFields")=arFormFields0 Session("FP_SavedValues")=arFormValues0 Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") Response.Redirect "http://www.beachentertainmentandtalent.com" End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> Band Prices

Please describe what type of band that you would like?
What types of music?
 Variety Rock Big Band Swing Top Forty Dance Jazz CountryTropical Reggae Beach Classic Rock Dance Latin 50's 60's 70's 80's 90's Today's

How many musicians would you like? (4 or more?)
 
Band(4 piece: Guitar, Bass, Drums, and Keyboards.)
Would you like additional musicians?
Keyboards / Piano / Organ Horn Section Saxophone Trumpet
Trombone Congas / Percussionist Female Vocalist Dancers

What is the date of the event?
In what city is the event being held?
n what State is the event being held?
Event Venue Name?
What is the starting time of the event?
What is the finishing time of the event?

Please type any additional questions, comments, or any other information below.


Please provide the following contact information:
Your information will be kept confidential.

Name/Title

Organization

Address

Address 2

City

State/Province

Zip Code

Phone 1

Phone 2

Email

URL