<%@LANGUAGE="VBSCRIPT"%> <% ' *** 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 & "?" & Server.HTMLEncode(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")) = "emailform") Then MM_editConnection = MM_sign_STRING MM_editTable = "tblemailnews" MM_editRedirectUrl = "goprocess.asp" MM_fieldsStr = "name1|value" MM_columnsStr = "emailnews|',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 %> MOTOR FLEET - SignElite, The most comprehensive insurance policy for the Sign & Graphics Industry

SignElite - THE Insurance policy for the sign and graphics industry! SignElite - THE Insurance policy for the sign and graphics industry!
SignElite - THE Insurance policy for the sign and graphics industry!
SignElite - THE Insurance policy for the sign and graphics industry!
SignElite - THE Insurance policy for the sign and graphics industry!
                   
  Navigate
       
    Standard Covers
   
  Property Cover
  Business Interruption
  Liability
  Hand Tools
  Money
  Computers
  Legal Expenses
  Contract Works
  Personal Accident
  Directors & Officers
   
Optional Policy Covers
   
  Customers Vehicles
  Terrorism
   
Additional Covers
   
  Professional Indemnity
  Commercial Vehicle
  Motor Fleet
       
.
  Options Services
       
      Health & Safety
       
 
       
  Motor Fleet Call Me
     
   

Not an automatic cover with the SignElite product as standard but, we can cover your
vehicles used within the business, these may be a mixture of Vans, HGV or
Business Cars.

Whilst we can place multi-vehicles, once you have 3 or more we can look at these under a fleet contract.

Fleet quotations are very simple and straight forward, all we require from you is vehicle and driver details, your fleet experience or no claims discount.

Call us to discuss your fleet requirements now on 0845 241 8550
or direct to the SignElite team:

TEL: 0845 241 8550
FAX: 0845 241 8560

Principal Contacts:

Lucy Dabell 0845 241 8551 (Commercial Motor -None Fleet Enquiries)
lucy@realinsurance.net

Steve Taylor 0845 241 8559 (Large & Corporate Sign Risks)
stevet@realinsurance.net

John Stafford 0845 241 8557
johns@realinsurance.net

Anne Jones 0845 241 8553
anne@realinsurance.net

Jenny Bonsor 0845 241 8550
jenny@realinsurance.net



 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
   
  Real Insurance Brokers is a trading style of Paul Mason Insurance Brokers Ltd which is authorised and regulated by the Financial Services Authority, Number 301589 © Real Insurance Brokers 2006