<% ' 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 = 28591 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("Band_Form_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(17) Dim arFormDBFields0(17) Dim arFormValues0(17) arFormFields0(0) = "Contact_With_Ad_Rates" arFormDBFields0(0) = "Contact_With_Ad_Rates" arFormValues0(0) = Request("Contact_With_Ad_Rates") arFormFields0(1) = "Band_Email" arFormDBFields0(1) = "Band_Email" arFormValues0(1) = Request("Band_Email") arFormFields0(2) = "Should_Contact_Venues" arFormDBFields0(2) = "Should_Contact_Venues" arFormValues0(2) = Request("Should_Contact_Venues") arFormFields0(3) = "Frequent_Venues" arFormDBFields0(3) = "Frequent_Venues" arFormValues0(3) = Request("Frequent_Venues") arFormFields0(4) = "Band_Name" arFormDBFields0(4) = "Band_Name" arFormValues0(4) = Request("Band_Name") arFormFields0(5) = "Address_City" arFormDBFields0(5) = "Address_City" arFormValues0(5) = Request("Address_City") arFormFields0(6) = "Times_Per_Month" arFormDBFields0(6) = "Times_Per_Month" arFormValues0(6) = Request("Times_Per_Month") arFormFields0(7) = "Band_Description" arFormDBFields0(7) = "Band_Description" arFormValues0(7) = Request("Band_Description") arFormFields0(8) = "Band_Genre" arFormDBFields0(8) = "Band_Genre" arFormValues0(8) = Request("Band_Genre") arFormFields0(9) = "Contact_Email" arFormDBFields0(9) = "Contact_Email" arFormValues0(9) = Request("Contact_Email") arFormFields0(10) = "Contact_Phone" arFormDBFields0(10) = "Contact_Phone" arFormValues0(10) = Request("Contact_Phone") arFormFields0(11) = "Address_Address" arFormDBFields0(11) = "Address_Address" arFormValues0(11) = Request("Address_Address") arFormFields0(12) = "Band_Contact" arFormDBFields0(12) = "Band_Contact" arFormValues0(12) = Request("Band_Contact") arFormFields0(13) = "Contact_About_Review" arFormDBFields0(13) = "Contact_About_Review" arFormValues0(13) = Request("Contact_About_Review") arFormFields0(14) = "Address_Zip" arFormDBFields0(14) = "Address_Zip" arFormValues0(14) = Request("Address_Zip") arFormFields0(15) = "Adress_State" arFormDBFields0(15) = "Adress_State" arFormValues0(15) = Request("Adress_State") arFormFields0(16) = "Band_Website" arFormDBFields0(16) = "Band_Website" arFormValues0(16) = Request("Band_Website") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type" End If If Request.ServerVariables("REMOTE_HOST") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name" 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 FP_FormConfirmation "text/html; charset=iso-8859-1",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "Band_Form.asp",_ "Return to the form." End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> MODEweekly | Music Guide Band Form
Don't miss the most complete Music Guide for Central Pennsylvania Musicians, Management, and Retailers

GUIDE BAND FORM

BANDS:
It is important 
that you complete 
the BAND FORM 
as accurately, and 
as soon as possible.

MODE Weekly's 
Annual Music Guide
Won't Be Complete
Without You.

PLEASE TELL YOUR
FELLOW MUSICIANS
Listings Are Free!

MODE Weekly Sixth Annual
Music Guide
2003

Bands!  Fill Out This Form Only Once.
Please note we are now accepting additions to the online edition only.

 

Band/Musician Name:

Band Genre:

Band Website:

Band E-Mail:

 

Band Contact:

 

Contact Address:

Address:
City:
State:
Zip:


Contact Phone:

Contact E-Mail:

 

Please describe your sound/band in 10 words or less:

How many times per month do you perform in Central PA?

At which venues do you most frequently play?


You should contact these venues to be included in the Music Guide.

I/we would like to be contacted about display ad rates.

I/we would like to be contacted about a CD or band review.

CLICK SUBMIT ONLY ONCE!

 

 


© 1990-2002. All Rights Reserved
Powered By: PA Network • Newman Design Consultants • Bad Humor