British Sign and Graphics Association - Signs, Signmakers, Sign Equipment, Sign Materials, Technical Guidelines, Training

<%@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 %> British Sign and Graphics Association - Signs, Signmakers, Sign Equipment, Sign Materials, Technical Guidelines, Training

SignElite - THE Insurance policy for the sign and graphics industry!

Navigate

Standard Covers

Property Cover

Business Interruption

Optional Policy Covers

Customers Vehicles

Terrorism

Additional Covers

Professional Indemnity

Commercial Vehicle

Motor Fleet

		Services

			Health & Safety

BSGA

British Signs & Graphics Association

The British Sign and Graphics Association (BSGA), and its forerunner organisations, has been representing the interests of sign makers and other businesses associated with the sign industry in the UK since 1918.

Today, members include every type and size of sign business, from craftsman signwriters through companies that manufacture architectural and illuminated signage to those that specialise in the production of vinyl signage, vehicle liveries and digitally produced signs.

The Association also represents a number of other sign related business sectors including sign installers, sign designers, consultants and businesses that manufacture and distribute products, materials and equipment used in sign making.

Until the 31st December 2007 you can join the BSGA for 20% less through SignElite. Just print off the certificate when applying - simple as that! Whats BSGA members also enjoy a 10% discount on their insurance.


	=	20% off first year’s pro rata membership of the BSGA 10% Discount for BSGA Members from your insurance premium.**

	Simply download the certificate below, click on the BSGA logo above. When you apply for membership of the Association let them know you have the certificate to qualify for the 20% off your first years pro-rata membership.



	** Note, the discount shown is applicable to the BSGA only and cannot be used in conjunction with any other offer from SignElite Partners. The 10% Discount for SignElite policyholders is deducted before Insurance Premium Tax at the current rate. This offer EXCLUDES customers vehicle road risk policies as well as Commercial Vehicle, Motor Fleet or Private Car. For existing policy holders joining the BSGA mid way through the insurance policy period the discount will be from the first renewal, no mid term return of premium will be available.


	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