<%@LANGUAGE="VBSCRIPT" CODEPAGE="1251"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_click2stay_STRING MM_editTable = "brochures" MM_editRedirectUrl = "../index.htm" MM_fieldsStr = "Name|value|Surname|value|Address1|value|Address2|value|Town|value|County|value|Postcode|value|Selection1|value|Other|value" MM_columnsStr = "Name|',none,''|Surname|',none,''|Address1|',none,''|Address2|',none,''|Town|',none,''|County|',none,''|Postcode|',none,''|Selection1|none,1,0|Other|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim Brochures Dim Brochures_numRows Set Brochures = Server.CreateObject("ADODB.Recordset") Brochures.ActiveConnection = MM_click2stay_STRING Brochures.Source = "SELECT Name, Surname, Address1, Address2, Town, County, Postcode, Selection1, Date FROM brochures" Brochures.CursorType = 0 Brochures.CursorLocation = 2 Brochures.LockType = 1 Brochures.Open() Brochures_numRows = 0 %> Brochure Request for Torbay and District
Brochure Request
BROCHURE REQUEST TO TORQUAY
 
SITE DIRECTORY
 
Email :
Name :
Subscribe
Un-Subscribe

 

 
brochure request, torquay, torbay, Devon
ATTRACTIONS AND A MAP BY POST
Before you come to Torquay and Torbay why not get a good selection of brochures sent by mail so you can plan events and let the kids choose for themselves where and when! These brochures have times, attractions, discount information and much more.

We have the following brochures available (see below), all of which will be dispatched by return post. Please note: These can only be mailed to the UK mainland. Due to the large number despatched there is a 1.50GBP surcharge for postage. This can be paid by Paypal.
  • Devon 2005 with top attractions, road map, beach guide, tide times
  • Leaflet for Quaywest, "Wet and Wild", Goodrington, Paignton
  • Leaflet for "Steam Trains of Devon" and the "Dart Valley Line"
  • "Living Coasts" Torquay's Coastal Zoo
  • Leaflet for Paignton Zoo
  • Leaflet for "Kents Cavern's Prehistoric Caves"
 
home    |    accommodation    |    maps    |    attractions    |    beaches    |    kids    |    guide
torquay.com © 2004 | Privacy Policy | Terms Of Use
<% Brochures.Close() Set Brochures = Nothing %>