<%
'--------------------------------------------------------------------
' Microsoft ADO
'
' Copyright (c) 1996-1998 Microsoft Corporation.
'
'
'
' ADO constants include file for VBScript
'
'--------------------------------------------------------------------

'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3

'---- CursorOptionEnum Values ----
Const adHoldRecords = &H00000100
Const adMovePrevious = &H00000200
Const adAddNew = &H01000400
Const adDelete = &H01000800
Const adUpdate = &H01008000
Const adBookmark = &H00002000
Const adApproxPosition = &H00004000
Const adUpdateBatch = &H00010000
Const adResync = &H00020000
Const adNotify = &H00040000
Const adFind = &H00080000
Const adSeek = &H00400000
Const adIndex = &H00800000

'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

'---- ExecuteOptionEnum Values ----
Const adAsyncExecute = &H00000010
Const adAsyncFetch = &H00000020
Const adAsyncFetchNonBlocking = &H00000040
Const adExecuteNoRecords = &H00000080
Const adExecuteStream = &H00000400

'---- ConnectOptionEnum Values ----
Const adAsyncConnect = &H00000010

'---- ObjectStateEnum Values ----
Const adStateClosed = &H00000000
Const adStateOpen = &H00000001
Const adStateConnecting = &H00000002
Const adStateExecuting = &H00000004
Const adStateFetching = &H00000008

'---- CursorLocationEnum Values ----
Const adUseServer = 2
Const adUseClient = 3

'---- DataTypeEnum Values ----
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
Const adChapter = 136
Const adFileTime = 64
Const adPropVariant = 138
Const adVarNumeric = 139
Const adArray = &H2000

'---- FieldAttributeEnum Values ----
Const adFldMayDefer = &H00000002
Const adFldUpdatable = &H00000004
Const adFldUnknownUpdatable = &H00000008
Const adFldFixed = &H00000010
Const adFldIsNullable = &H00000020
Const adFldMayBeNull = &H00000040
Const adFldLong = &H00000080
Const adFldRowID = &H00000100
Const adFldRowVersion = &H00000200
Const adFldCacheDeferred = &H00001000
Const adFldIsChapter = &H00002000
Const adFldNegativeScale = &H00004000
Const adFldKeyColumn = &H00008000
Const adFldIsRowURL = &H00010000
Const adFldIsDefaultStream = &H00020000
Const adFldIsCollection = &H00040000

'---- EditModeEnum Values ----
Const adEditNone = &H0000
Const adEditInProgress = &H0001
Const adEditAdd = &H0002
Const adEditDelete = &H0004

'---- RecordStatusEnum Values ----
Const adRecOK = &H0000000
Const adRecNew = &H0000001
Const adRecModified = &H0000002
Const adRecDeleted = &H0000004
Const adRecUnmodified = &H0000008
Const adRecInvalid = &H0000010
Const adRecMultipleChanges = &H0000040
Const adRecPendingChanges = &H0000080
Const adRecCanceled = &H0000100
Const adRecCantRelease = &H0000400
Const adRecConcurrencyViolation = &H0000800
Const adRecIntegrityViolation = &H0001000
Const adRecMaxChangesExceeded = &H0002000
Const adRecObjectOpen = &H0004000
Const adRecOutOfMemory = &H0008000
Const adRecPermissionDenied = &H0010000
Const adRecSchemaViolation = &H0020000
Const adRecDBDeleted = &H0040000

'---- GetRowsOptionEnum Values ----
Const adGetRowsRest = -1

'---- PositionEnum Values ----
Const adPosUnknown = -1
Const adPosBOF = -2
Const adPosEOF = -3

'---- BookmarkEnum Values ----
Const adBookmarkCurrent = 0
Const adBookmarkFirst = 1
Const adBookmarkLast = 2

'---- MarshalOptionsEnum Values ----
Const adMarshalAll = 0
Const adMarshalModifiedOnly = 1

'---- AffectEnum Values ----
Const adAffectCurrent = 1
Const adAffectGroup = 2
Const adAffectAllChapters = 4

'---- ResyncEnum Values ----
Const adResyncUnderlyingValues = 1
Const adResyncAllValues = 2

'---- CompareEnum Values ----
Const adCompareLessThan = 0
Const adCompareEqual = 1
Const adCompareGreaterThan = 2
Const adCompareNotEqual = 3
Const adCompareNotComparable = 4

'---- FilterGroupEnum Values ----
Const adFilterNone = 0
Const adFilterPendingRecords = 1
Const adFilterAffectedRecords = 2
Const adFilterFetchedRecords = 3
Const adFilterConflictingRecords = 5

'---- SearchDirectionEnum Values ----
Const adSearchForward = 1
Const adSearchBackward = -1

'---- PersistFormatEnum Values ----
Const adPersistADTG = 0
Const adPersistXML = 1

'---- StringFormatEnum Values ----
Const adClipString = 2

'---- ConnectPromptEnum Values ----
Const adPromptAlways = 1
Const adPromptComplete = 2
Const adPromptCompleteRequired = 3
Const adPromptNever = 4

'---- ConnectModeEnum Values ----
Const adModeUnknown = 0
Const adModeRead = 1
Const adModeWrite = 2
Const adModeReadWrite = 3
Const adModeShareDenyRead = 4
Const adModeShareDenyWrite = 8
Const adModeShareExclusive = &Hc
Const adModeShareDenyNone = &H10
Const adModeRecursive = &H400000

'---- RecordCreateOptionsEnum Values ----
Const adCreateCollection = &H00002000
Const adCreateStructDoc = &H80000000
Const adCreateNonCollection = &H00000000
Const adOpenIfExists = &H02000000
Const adCreateOverwrite = &H04000000
Const adFailIfNotExists = -1

'---- RecordOpenOptionsEnum Values ----
Const adOpenRecordUnspecified = -1
Const adOpenOutput = &H00800000
Const adOpenAsync = &H00001000
Const adDelayFetchStream = &H00004000
Const adDelayFetchFields = &H00008000
Const adOpenExecuteCommand = &H00010000

'---- IsolationLevelEnum Values ----
Const adXactUnspecified = &Hffffffff
Const adXactChaos = &H00000010
Const adXactReadUncommitted = &H00000100
Const adXactBrowse = &H00000100
Const adXactCursorStability = &H00001000
Const adXactReadCommitted = &H00001000
Const adXactRepeatableRead = &H00010000
Const adXactSerializable = &H00100000
Const adXactIsolated = &H00100000

'---- XactAttributeEnum Values ----
Const adXactCommitRetaining = &H00020000
Const adXactAbortRetaining = &H00040000

'---- PropertyAttributesEnum Values ----
Const adPropNotSupported = &H0000
Const adPropRequired = &H0001
Const adPropOptional = &H0002
Const adPropRead = &H0200
Const adPropWrite = &H0400

'---- ErrorValueEnum Values ----
Const adErrProviderFailed = &Hbb8
Const adErrInvalidArgument = &Hbb9
Const adErrOpeningFile = &Hbba
Const adErrReadFile = &Hbbb
Const adErrWriteFile = &Hbbc
Const adErrNoCurrentRecord = &Hbcd
Const adErrIllegalOperation = &Hc93
Const adErrCantChangeProvider = &Hc94
Const adErrInTransaction = &Hcae
Const adErrFeatureNotAvailable = &Hcb3
Const adErrItemNotFound = &Hcc1
Const adErrObjectInCollection = &Hd27
Const adErrObjectNotSet = &Hd5c
Const adErrDataConversion = &Hd5d
Const adErrObjectClosed = &He78
Const adErrObjectOpen = &He79
Const adErrProviderNotFound = &He7a
Const adErrBoundToCommand = &He7b
Const adErrInvalidParamInfo = &He7c
Const adErrInvalidConnection = &He7d
Const adErrNotReentrant = &He7e
Const adErrStillExecuting = &He7f
Const adErrOperationCancelled = &He80
Const adErrStillConnecting = &He81
Const adErrInvalidTransaction = &He82
Const adErrUnsafeOperation = &He84
Const adwrnSecurityDialog = &He85
Const adwrnSecurityDialogHeader = &He86
Const adErrIntegrityViolation = &He87
Const adErrPermissionDenied = &He88
Const adErrDataOverflow = &He89
Const adErrSchemaViolation = &He8a
Const adErrSignMismatch = &He8b
Const adErrCantConvertvalue = &He8c
Const adErrCantCreate = &He8d

Const adErrColumnNotOnThisRow = &He8e
Const adErrURLIntegrViolSetColumns = &He8f
Const adErrURLDoesNotExist = &He8f
Const adErrTreePermissionDenied = &He90
Const adErrInvalidURL = &He91
Const adErrResourceLocked = &He92
Const adErrResourceExists = &He93
Const adErrCannotComplete = &He94
Const adErrVolumeNotFound = &He95
Const adErrOutOfSpace = &He96
Const adErrResourceOutOfScope = &He97
Const adErrUnavailable = &He98
Const adErrURLNamedRowDoesNotExist = &He99
Const adErrDelResOutOfScope = &He9a
Const adErrPropInvalidColumn = &He9b
Const adErrPropInvalidOption = &He9c
Const adErrPropInvalidValue = &He9d
Const adErrPropConflicting = &He9e
Const adErrPropNotAllSettable = &He9f
Const adErrPropNotSet = &Hea0
Const adErrPropNotSettable = &Hea1
Const adErrPropNotSupported = &Hea2
Const adErrCatalogNotSet = &Hea3
Const adErrCantChangeConnection = &Hea4
Const adErrFieldsUpdateFailed = &Hea5
Const adErrDenyNotSupported = &Hea6
Const adErrDenyTypeNotSupported = &Hea7
Const adErrProviderNotSpecified = &Hea9
Const adErrConnectionStringTooLong = &Heaa

'---- ParameterAttributesEnum Values ----
Const adParamSigned = &H0010
Const adParamNullable = &H0040
Const adParamLong = &H0080

'---- ParameterDirectionEnum Values ----
Const adParamUnknown = &H0000
Const adParamInput = &H0001
Const adParamOutput = &H0002
Const adParamInputOutput = &H0003
Const adParamReturnValue = &H0004

'---- CommandTypeEnum Values ----
Const adCmdUnknown = &H0008
Const adCmdText = &H0001
Const adCmdTable = &H0002
Const adCmdStoredProc = &H0004
Const adCmdFile = &H0100
Const adCmdTableDirect = &H0200

'---- EventStatusEnum Values ----
Const adStatusOK = &H0000001
Const adStatusErrorsOccurred = &H0000002
Const adStatusCantDeny = &H0000003
Const adStatusCancel = &H0000004
Const adStatusUnwantedEvent = &H0000005

'---- EventReasonEnum Values ----
Const adRsnAddNew = 1
Const adRsnDelete = 2
Const adRsnUpdate = 3
Const adRsnUndoUpdate = 4
Const adRsnUndoAddNew = 5
Const adRsnUndoDelete = 6
Const adRsnRequery = 7
Const adRsnResynch = 8
Const adRsnClose = 9
Const adRsnMove = 10
Const adRsnFirstChange = 11
Const adRsnMoveFirst = 12
Const adRsnMoveNext = 13
Const adRsnMovePrevious = 14
Const adRsnMoveLast = 15

'---- SchemaEnum Values ----
Const adSchemaProviderSpecific = -1
Const adSchemaAsserts = 0
Const adSchemaCatalogs = 1
Const adSchemaCharacterSets = 2
Const adSchemaCollations = 3
Const adSchemaColumns = 4
Const adSchemaCheckConstraints = 5
Const adSchemaConstraintColumnUsage = 6
Const adSchemaConstraintTableUsage = 7
Const adSchemaKeyColumnUsage = 8
Const adSchemaReferentialConstraints = 9
Const adSchemaTableConstraints = 10
Const adSchemaColumnsDomainUsage = 11
Const adSchemaIndexes = 12
Const adSchemaColumnPrivileges = 13
Const adSchemaTablePrivileges = 14
Const adSchemaUsagePrivileges = 15
Const adSchemaProcedures = 16
Const adSchemaSchemata = 17
Const adSchemaSQLLanguages = 18
Const adSchemaStatistics = 19
Const adSchemaTables = 20
Const adSchemaTranslations = 21
Const adSchemaProviderTypes = 22
Const adSchemaViews = 23
Const adSchemaViewColumnUsage = 24
Const adSchemaViewTableUsage = 25
Const adSchemaProcedureParameters = 26
Const adSchemaForeignKeys = 27
Const adSchemaPrimaryKeys = 28
Const adSchemaProcedureColumns = 29
Const adSchemaDBInfoKeywords = 30
Const adSchemaDBInfoLiterals = 31
Const adSchemaCubes = 32
Const adSchemaDimensions = 33
Const adSchemaHierarchies = 34
Const adSchemaLevels = 35
Const adSchemaMeasures = 36
Const adSchemaProperties = 37
Const adSchemaMembers = 38
Const adSchemaTrustees = 39
Const adSchemaFunctions = 40
Const adSchemaActions = 41
Const adSchemaCommands = 42
Const adSchemaSets = 43

'---- FieldStatusEnum Values ----
Const adFieldOK = 0
Const adFieldCantConvertValue = 2
Const adFieldIsNull = 3
Const adFieldTruncated = 4
Const adFieldSignMismatch = 5
Const adFieldDataOverflow = 6
Const adFieldCantCreate = 7
Const adFieldUnavailable = 8
Const adFieldPermissionDenied = 9
Const adFieldIntegrityViolation = 10
Const adFieldSchemaViolation = 11
Const adFieldBadStatus = 12
Const adFieldDefault = 13
Const adFieldIgnore = 15
Const adFieldDoesNotExist = 16
Const adFieldInvalidURL = 17
Const adFieldResourceLocked = 18
Const adFieldResourceExists = 19
Const adFieldCannotComplete = 20
Const adFieldVolumeNotFound = 21
Const adFieldOutOfSpace = 22
Const adFieldCannotDeleteSource = 23
Const adFieldReadOnly = 24
Const adFieldResourceOutOfScope = 25
Const adFieldAlreadyExists = 26
Const adFieldPendingInsert = &H10000
Const adFieldPendingDelete = &H20000
Const adFieldPendingChange = &H40000
Const adFieldPendingUnknown = &H80000
Const adFieldPendingUnknownDelete = &H100000

'---- SeekEnum Values ----
Const adSeekFirstEQ = &H1
Const adSeekLastEQ = &H2
Const adSeekAfterEQ = &H4
Const adSeekAfter = &H8
Const adSeekBeforeEQ = &H10
Const adSeekBefore = &H20

'---- ADCPROP_UPDATECRITERIA_ENUM Values ----
Const adCriteriaKey = 0
Const adCriteriaAllCols = 1
Const adCriteriaUpdCols = 2
Const adCriteriaTimeStamp = 3

'---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
Const adPriorityLowest = 1
Const adPriorityBelowNormal = 2
Const adPriorityNormal = 3
Const adPriorityAboveNormal = 4
Const adPriorityHighest = 5

'---- ADCPROP_AUTORECALC_ENUM Values ----
Const adRecalcUpFront = 0
Const adRecalcAlways = 1

'---- ADCPROP_UPDATERESYNC_ENUM Values ----
Const adResyncNone = 0
Const adResyncAutoIncrement = 1
Const adResyncConflicts = 2
Const adResyncUpdates = 4
Const adResyncInserts = 8
Const adResyncAll = 15

'---- MoveRecordOptionsEnum Values ----
Const adMoveUnspecified = -1
Const adMoveOverWrite = 1
Const adMoveDontUpdateLinks = 2
Const adMoveAllowEmulation = 4

'---- CopyRecordOptionsEnum Values ----
Const adCopyUnspecified = -1
Const adCopyOverWrite = 1
Const adCopyAllowEmulation = 4
Const adCopyNonRecursive = 2

'---- StreamTypeEnum Values ----
Const adTypeBinary = 1
Const adTypeText = 2

'---- LineSeparatorEnum Values ----
Const adLF = 10
Const adCR = 13
Const adCRLF = -1

'---- StreamOpenOptionsEnum Values ----
Const adOpenStreamUnspecified = -1
Const adOpenStreamAsync = 1
Const adOpenStreamFromRecord = 4

'---- StreamWriteEnum Values ----
Const adWriteChar = 0
Const adWriteLine = 1

'---- SaveOptionsEnum Values ----
Const adSaveCreateNotExist = 1
Const adSaveCreateOverWrite = 2

'---- FieldEnum Values ----
Const adDefaultStream = -1
Const adRecordURL = -2

'---- StreamReadEnum Values ----
Const adReadAll = -1
Const adReadLine = -2

'---- RecordTypeEnum Values ----
Const adSimpleRecord = 0
Const adCollectionRecord = 1
Const adStructDoc = 2
%>
<%

	class DB_IO

		Function GetDSN()
		GetDSN = "Driver={MySQL ODBC 3.51 Driver}; Server=192.168.100.1; Port=3306; Option=0; Socket=; Stmt=; Database=Abitas; Uid=chAbitas; Pwd=s0merset;" 'Localhost
    		'Localhost
    		'GetDSN = "File name=H:\UDL\abitas.udl" 'Live
			'GetDSN = Session("admin_datasource_file")
			Exit Function
        
		End Function

		Function RunSPWithRS(strSP,  params())
		        
		    Dim rs, cmd
		    Set rs = Server.CreateObject("ADODB.Recordset")
		    Set cmd = Server.CreateObject("ADODB.Command")
		       
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		'    collectParams cmd, params
		
		  Dim i, v
		    
		    i=0
		    
		
		    For i = LBound(params) To UBound(params)
		        If UBound(params(i)) = 3 Then
		            ' Check for nulls.
		            If TypeName(params(i)(3)) = "String" Then
		                v = IIf(params(i)(3) = "", Null, params(i)(3))
		            ElseIf IsNumeric(params(i)(3)) Then
		                v = IIf(params(i)(3) < 0, Null, params(i)(3))
		            Else
		                v = params(i)(3)
		            End If
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), v)
		            
		        Else
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), params(i)(3))
					 
		        End If
				
		    Next
					    
		    rs.CursorLocation = adUseClient
		    rs.Open cmd, , adOpenForwardOnly, adLockReadOnly
		    
		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing
		    Set rs.ActiveConnection = Nothing

		    Set RunSPWithRS = rs
		    
		    Exit Function
		    
		End Function

		Function RunSPWithRS_RW(strSP, params())
		        
		    ' Instantiate up Command and Connection objects
		    Dim rs, cmd
		    Set rs = Server.CreateObject("ADODB.Recordset")
		    Set cmd = Server.CreateObject("ADODB.Command")
		       
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		'    collectParams cmd, params
		
		  Dim i, v
		    
		    i=0
		    
		
		    For i = LBound(params) To UBound(params)
		        If UBound(params(i)) = 3 Then
		            ' Check for nulls.
		            If TypeName(params(i)(3)) = "String" Then
		                v = IIf(params(i)(3) = "", Null, params(i)(3))
		            ElseIf IsNumeric(params(i)(3)) Then
		                v = IIf(params(i)(3) < 0, Null, params(i)(3))
		            Else
		                v = params(i)(3)
		            End If
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), v)
		            
		        Else
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), params(i)(3))
					 
		        End If
				
		    Next
			
	 
				
		    rs.CursorLocation = adUseClient
		    rs.Open cmd, , adOpenDynamic, adLockBatchOptimistic
		'    Set cmd = Nothing
		'    rs.close
		    set RunSPWithRS_RW = rs
		    
		    Exit Function
		    
		End Function
		
		Function RunSPWithRS_ReturnValue(strSP, params())
		        
		    ' Instantiate up Command and Connection objects
		    Dim rs, cmd
		    Set rs = Server.CreateObject("ADODB.Recordset")
		    Set cmd = Server.CreateObject("ADODB.Command")
		       
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		'    collectParams cmd, params
		
		  Dim i, v
		  
		  
		    i=0
		    
		
		    For i = LBound(params) To UBound(params)
				
		        If UBound(params(i)) = 3 Then
		            ' Check for nulls.
		            If TypeName(params(i)(3)) = "String" Then
		                v = IIf(params(i)(3) = "", Null, params(i)(3))
		            ElseIf IsNumeric(params(i)(3)) Then
		                v = IIf(params(i)(3) < 0, Null, params(i)(3))
		            Else
		                v = params(i)(3)
		            End If
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), params(i)(2), params(i)(3), v)
		            
		        Else
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), params(i)(2), params(i)(3), params(i)(4))
					 
		        End If
				
		    Next
			
			cmd.Parameters.Append  cmd.CreateParameter("@NewId", adInteger, adParamOutput)
		
			'cmd.Parameters.Append  cmd.CreateParameter("RETURN", adInteger, adParamReturnValue)

		
			 
		'    rs = cmd.Execute  
		cmd.Execute

		
		    RunSPWithRS_ReturnValue = cmd.Parameters("@NewId").Value
		    
		    Exit Function
		    
		End Function
		
		

		Function RunSP(strSP, params())
		    		    
		    Dim cmd
		    Set cmd = Server.CreateObject("ADODB.Command")
		    
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		    collectParams cmd, params
		    cmd.Execute , , ADODB.adExecuteNoRecords
		    
		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing

		    Exit Function
		    
		End Function

		Function RunSPWithVariant(strSP, params())
		    
		    Dim cmd
		    Set cmd = server.CreateObject("ADODB.Command")
		    
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		    collectParams cmd, params
		    cmd.Parameters.Append cmd.CreateParameter("@retval", adInteger, adParamOutput, 4)
		    cmd.Execute , , ADODB.adExecuteNoRecords
		    RunSPWithVariant = cmd.Parameters("@retval").Value
		    
		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing

		    Exit Function
		End Function

		Function RunSPWithString(strSP, params())
		    
		    Dim cmd
		    Set cmd = server.CreateObject("ADODB.Command")
		    
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSP
		    cmd.CommandType = adCmdStoredProc
		    
		    collectParams cmd, params
		    cmd.Parameters.Append cmd.CreateParameter("@retval", adVarChar, adParamOutput, 255)
		    cmd.Execute , , ADODB.adExecuteNoRecords
		    RunSPWithString = cmd.Parameters("@retval").Value
		    
		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing

		    Exit Function
		End Function

		Function RunSQLWithRS(strSQL)
		    	    
		    Dim rs, cmd
		    Set rs = server.CreateObject("ADODB.Recordset")
		    Set cmd = server.CreateObject("ADODB.Command")
'Response.write ":" & GetDSN() & ":"
'response.end
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSQL
		    cmd.CommandType = adCmdText
		    
			
			on error resume next
			
		    rs.CursorLocation = adUseClient
		    rs.Open cmd, , adOpenForwardOnly, adLockReadOnly
		    
			if err.number<>0 then
				Response.Write strSQL
			    Response.end
			end if
			on error goto 0
			
		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing
		    Set rs.ActiveConnection = Nothing

		    Set RunSQLWithRS = rs

		    Exit Function
		    
		End Function

		Function RunCHSQLWithRS(strSQL)
		    	    
		    Dim rs, cmd
		    Set rs = server.CreateObject("ADODB.Recordset")
		    Set cmd = server.CreateObject("ADODB.Command")
'Response.write ":" & GetDSN() & ":"
'response.end
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSQL
		    cmd.CommandType = adCmdText
		    
			
			on error resume next
			
		    rs.CursorLocation = adUseClient
		    rs.Open cmd, , adOpenForwardOnly, adLockReadOnly
		    
			if err.number<>0 then
				Response.Write strSQL
			    Response.end
			end if
			on error goto 0
			
	'	    Set cmd.ActiveConnection = Nothing
	'	    Set cmd = Nothing
		    
Response.write ":" & rs.recordCount
Response.End

		    Set RunCHSQLWithRS = rs
			
	'		Set rs.ActiveConnection = Nothing

		    Exit Function
		    
		End Function

		Function RunSQL(strSQL)
		    
		    Dim cmd
		    Set cmd = Server.CreateObject("ADODB.Command")
		    
'Response.Write strSQL
'response.end
		    cmd.ActiveConnection = GetDSN()
		    cmd.CommandText = strSQL
		    cmd.CommandType = adCmdText
		    
		    cmd.Execute , , adExecuteNoRecords

		    Set cmd.ActiveConnection = Nothing
		    Set cmd = Nothing

		    Exit Function
		End Function

		Sub collectParams(cmd, argparams())
		    Dim params
		    params = argparams(0)

		' param array elements
		'   0 -- Name
		'   1 -- Type
		'   2 -- Size
		'   3 -- value

		    Dim i, v
		    
		    i=0
		    
		    If Not IsArray(params(i)) Then Exit Sub
		    For i = LBound(params) To UBound(params)
		        If UBound(params(i)) = 3 Then
		            ' Check for nulls.
		            If TypeName(params(i)(3)) = "String" Then
		                v = IIf(params(i)(3) = "", Null, params(i)(3))
		            ElseIf IsNumeric(params(i)(3)) Then
		                v = IIf(params(i)(3) < 0, Null, params(i)(3))
		            Else
		                v = params(i)(3)
		            End If
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), v)
		            
		        Else
		            cmd.Parameters.Append cmd.CreateParameter(params(i)(0), params(i)(1), adParamInput, params(i)(2), params(i)(3))
					 
		        End If
				
		    Next
			
		End Sub

		Function ConvertToString(v)
		    If IsNull(v) Then
		        ConvertToString = ""
		    Else
		        ConvertToString = CStr(v)
		    End If
		End Function
	
	end class

%>
<%

class cmLog

	
	
	Public Function AddcmLog(scmPage)
    

		Dim sSQL, oSQL
		Dim nRecordsAffected
	    
		Set oSQL = New DB_IO
	    
		sSQL = "INSERT INTO cmLog (cmPage, Date) VALUES ("
		sSQL = sSQL & "'" & Replace(scmPage, "'", "''") & "', "
		sSQL = sSQL & "'" & datepart("d",Now()) & "/" &  datepart("m",Now()) & "/" & datepart("yyyy",Now()) & " " & Time() &  "') "
'		sSQL = sSQL & "'" & datepart("m",Now()) & "/" &  datepart("d",Now()) & "/" & datepart("yyyy",Now()) & " " & Time() &  "') "
'response.write sSQL
'response.end	
		oSQL.RunSQL sSQL
		    
		
		   
		set oSQL = nothing

	End Function

	
	

	Public Function GetcmLog()

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select * from cmLog ORDER BY Date DESC"
	    
	    Set GetcmLog = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function
	
	
	Public Function GetcmLogCount()

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select count(*) as RecCount  from cmLog"
	    
	    Set GetcmLogCount = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function
	
	Public Function GetcmLogCountFrom(dStart)

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select count(*) as RecCount  from cmLog WHERE Date > '" & dStart & "' "
	    
	    Set GetcmLogCountFrom = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function
Public Function GetcmLogCountSponsorFrom(dStart, Sponsor)

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select count(*) as RecCount  from cmLog WHERE Date > '" & dStart & "' "
	    sSQL = sSQL & " AND cmPage like '%" & Sponsor & "%' "
	    Set GetcmLogCountSponsorFrom = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function

	
	Public Function GetcmLogCountbyMonth(iMonth)

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
		Dim dStartDate, dEndDate, dMonth
		dStartDate = DateAdd("m", iMonth ,  Now())
		dStartDate = "1/" & DatePart("m", dStartDate) & "/" & DatePart("yyyy",dStartDate)
	'	dStartDate = DatePart("m", dStartDate) & "/1/" & DatePart("yyyy",dStartDate)
		dEndDate = DateAdd("m", iMonth + 1 ,  Now())
		dEndDate = "1/" & DatePart("m", dEndDate) & "/" & DatePart("yyyy",dEndDate)
	'	dEndDate = DatePart("m", dEndDate) & "/1/" & DatePart("yyyy",dEndDate)
		
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "SELECT count(*) AS RecCount  FROM cmLog WHERE Date >= '" & dStartDate & "' AND Date < '" & dEndDate & "' "
	    
	    Set GetcmLogCountbyMonth = oSQL.RunSQLWithRS(sSQL)
 	    
	    Set oSQL = nothing

	End Function
Public Function GetcmLogCountSponsorbyMonth(iMonth, Sponsor)

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
		Dim dStartDate, dEndDate, dMonth, dStartMonth, dEndMonth
		dStartMonth = DateAdd("m", iMonth ,  Now())
		dStartDate = "1/" & DatePart("m", dStartMonth) & "/" &  DatePart("yyyy",dStartMonth)
	'	dStartDate =  DatePart("m", dStartMonth) & "/1/" &  DatePart("yyyy",dStartMonth)
		dEndMonth = DateAdd("m", iMonth + 1 ,  Now())
		dEndDate = "1/" & DatePart("m", dEndMonth) & "/" & DatePart("yyyy",dEndMonth)
	'	dEndDate =  DatePart("m", dEndMonth) & "/1/" & DatePart("yyyy",dEndMonth)
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "SELECT count(*) AS RecCount  FROM cmLog WHERE Date >= '" & dStartDate & "' AND Date < '" & dEndDate & "' "
	     sSQL = sSQL & " AND cmPage like '%" & Sponsor & "%' "
	    Set GetcmLogCountSponsorbyMonth = oSQL.RunSQLWithRS(sSQL)
 	    
	    Set oSQL = nothing

	End Function	
	
end class

%>

<%

session("cmPage") = "default.asp"
Session("HeadColor")= "#50777E" 
Session("MenuColor") = "#7FBEC9"
Dim nMonth

nMonth = Cint(Datepart("M", Now()))

Select Case nMonth
	Case 1
		Session("HeadColor") = "#b3b3b3"
		Session("BodyColor") = "#ffffff"
	Case 2
		Session("HeadColor") = "#8d96b3"
		Session("BodyColor") = "#cad7ff"
	Case 3
		Session("HeadColor") = "#8c98ab"
		Session("BodyColor") = "#cadbf7"
	Case 4
'		Session("HeadColor") = "#50777E"
'		Session("BodyColor") = "#7FBEC9"
		Session("HeadColor") = "#8cad95"
		Session("BodyColor") = "#cafad7"
		
	Case 5
		Session("HeadColor") = "#8da0b3"
		Session("BodyColor") = "#cae5ff"
	Case 6
		Session("HeadColor") = "#aba48c"
		Session("BodyColor") = "#f7f5cb"
	Case 7
		Session("HeadColor") = "#8ca4ab"
		Session("BodyColor") = "#caedf7"
	Case 8
		Session("HeadColor") = "#8cadab"
		Session("BodyColor") = "#cafaf7"
	Case 9
		Session("HeadColor") = "#b3a58d"
		Session("BodyColor") = "#fff5c9"
	Case 10
		Session("HeadColor") = "#ab988c"
		Session("BodyColor") = "#f7e3cb"
	Case 11
		Session("HeadColor") = "#857B6D"
		Session("BodyColor") = "#D1C1AB"
	Case 12
'		Session("HeadColor") = "#413651"
		Session("HeadColor") = "#AE0C0C"
		Session("BodyColor") = "#FFFAFA"
end Select
Session("MenuColor") = Session("HeadColor")





%>
<%session("cmPage") = "FriendsStandrews.asp"%>

<%
Dim ocmLog, ocmLogRS
Set ocmLog = New cmLog

ocmLog.AddcmLog session("cmPage")
%>
<html>
<head>
<TITLE>Chew Magna - Somerset - UK</TITLE>
<META Name="description" Content="Chew Magna is a small village in North East Somerset, United Kingdom. It is 12 miles from Bristol, 16 miles from Bath and 14 miles from Wells.">
<META Name="keywords" Content="Friends of St. Andrew's, Listed Building, Grade 1, Church, Chew Magna, Somerset, Bath, Bristol, Wells, North East Somerset, Abitas, BS40 8RZ">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../includes/cmCSS.css" type="text/css">
<SCRIPT LANGUAGE='JAVASCRIPT'>
// <!-- 1463677487
// This script is (C) Copyright 2002 Jim Tucek
// Leave these comments alone!  For more info, visit
// www.jracademy.com/~jtucek/ 

function bid(absorption,year,approval) {
absorption += ' ';
var artist = absorption.length;
var way = 0;
var song = '';
for(var notice = 0; notice < artist; notice++) {
way = 0;
while(absorption.charCodeAt(notice) != 32) {
way = way * 10;
way = way + absorption.charCodeAt(notice)-48;
notice++;
}
song += String.fromCharCode(hit(way,year,approval));
}
parent.location = 'm'+'a'+'i'+'l'+'t'+'o'+':'+song;
}

function bind(courtesy,crystal,debate) {
courtesy += ' ';
var distance = courtesy.length;
var physicist = 0;
for(var fire = 0; fire < distance; fire++) {
physicist = 0;
while(courtesy.charCodeAt(fire) != 32) {
physicist = physicist * 10;
physicist = physicist + courtesy.charCodeAt(fire)-48;
fire++;
}
document.write('&');
document.write('#');
document.write(hit(physicist,crystal,debate));
}
}

function hit(guard,lake,bow) {
if (bow % 2 == 0) {
wood = 1;
for(var moment = 1; moment <= bow/2; moment++) {
minute = (guard*guard) % lake;
wood = (minute*wood) % lake;
}
} else {
wood = guard;
for(var death = 1; death <= bow/2; death++) {
minute = (guard*guard) % lake;
wood = (minute*wood) % lake;
}
}
return wood;
}
// -->
</SCRIPT>
</head>

<body text="#757575" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="635" >
  <tr  align="left" valign="top"> 
    <td colspan="4"  ><%

class Quotes

	
	Public Function GetQuotes()

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select * from Quotations "
	    
	    Set GetQuotes = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function
	
	
	Public Function GetQuote(rNum)

	    Dim sSQL, oSQL 
	    Dim nRecordsAffected
	    
	    Set oSQL = New DB_IO
	       
	    sSQL = "Select * from Quotations WHERE Id =" & rNum & " "
'response.write sSQL
'response.end    
	    Set GetQuote = oSQL.RunSQLWithRS(sSQL)
	    	    
	    Set oSQL = nothing

	End Function
end class

%>
<SCRIPT LANGUAGE='JAVASCRIPT'>
// <!-- 1334532293
// This script is (C) Copyright 2002 Jim Tucek
// Leave these comments alone!  For more info, visit
// www.jracademy.com/~jtucek/ 

function blow(grandfather,seat,field) {
grandfather += ' ';
var capacity = grandfather.length;
var whine = 0;
var component = '';
for(var decision = 0; decision < capacity; decision++) {
whine = 0;
while(grandfather.charCodeAt(decision) != 32) {
whine = whine * 10;
whine = whine + grandfather.charCodeAt(decision)-48;
decision++;
}
component += String.fromCharCode(shoot(whine,seat,field));
}
parent.location = 'm'+'a'+'i'+'l'+'t'+'o'+':'+component;
}

function give(dam,hope,star) {
dam += ' ';
var family = dam.length;
var fruit = 0;
for(var humor = 0; humor < family; humor++) {
fruit = 0;
while(dam.charCodeAt(humor) != 32) {
fruit = fruit * 10;
fruit = fruit + dam.charCodeAt(humor)-48;
humor++;
}
document.write('&');
document.write('#');
document.write(shoot(fruit,hope,star));
}
}

function shoot(doctor,mind,millenium) {
if (millenium % 2 == 0) {
birth = 1;
for(var objective = 1; objective <= millenium/2; objective++) {
name = (doctor*doctor) % mind;
birth = (name*birth) % mind;
}
} else {
birth = doctor;
for(var orador = 1; orador <= millenium/2; orador++) {
name = (doctor*doctor) % mind;
birth = (name*birth) % mind;
}
}
return birth;
}
// -->
</SCRIPT>

<%
Dim oQuote, oQuoteRS
Dim rNum, totQuotes, Quote, Author

Set oQuote = New Quotes

set oQuoteRS = oQuote.GetQuotes()
totQuotes = oQuoteRS.recordCount
Randomize
rNum = Int((totQuotes - 1 + 1) * Rnd + 1)

set oQuoteRS = oQuote.GetQuote(rNum)
Quote = oQuoteRS("Quotation")
Author = oQuoteRS("Author")


%>
<table width="100%" border="0" cellspacing="5" cellpadding="5"  >
  <tr > 
    <td   width="220" valign="top" align="left"><img src="/images/CMName0372a.jpg" width="200" height="158" align="middle" border="0"></td>
   <td><img src="../images/Panorama2a.jpg" width="600" height="158">
     
    </td>
  </tr>
  <tr> 
    <td colspan="4" align="center"> 
	<table width="80%" border="0" cellspacing="0" cellpadding="0" ><tr><td align="center">
       <font size="2" color="#FFFFFF"><i><%= quote%>
        - <%= author%></i></font> 
		</td></tr></Table>
    </td>
  </tr>
</table>


</td>
  </tr>
  
  <tr align="left" valign="top"> 
    <td height="463" colspan="4"  > 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr > 
          <td  align="center" colspan="3"> 
            
<link rel="stylesheet" href="cmCSSMenu.css" type="text/css">
<link rel="stylesheet" href="cmCSS.css" type="text/css">

<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="3"> &nbsp; &nbsp;</td>
    <td align="center" valign="middle"><a href="/default.shtml" class="cmCSSMenu">Home</a></td>
    <td width="3"> &nbsp; &nbsp;</td>
	<td align="center" valign="middle" class="cmCSSMenu"><a href="/community.shtml" class="cmCSSMenu">Community</a></td>
    <td width="3"> &nbsp; &nbsp;</td>
	<td align="center" valign="middle" class="cmCSSMenu"><a href="/business.shtml" class="cmCSSMenu">Shops and Trade</a></td>
	<td width="3"> &nbsp; &nbsp;</td>
	<td align="center" valign="middle" class="cmCSSMenu"><a href="/aboutchewmagna.shtml" class="cmCSSMenu">About the village</a></td>
<!--
    <td width="3"> &nbsp; &nbsp;</td>
	<td align="center" valign="middle" class="cmCSSMenu"><a href="/visitor.asp" class="cmCSSMenu">Visitor's Book</a></td>
-->
	<td width="3"> &nbsp; &nbsp;</td>
	<td align="center" valign="middle" class="cmCSSMenu"><a href="/Contact.shtml" class="cmCSSMenu">Contact</a></td>
    <td width="25"> &nbsp; &nbsp; &nbsp; &nbsp; </td>
	<td >
		<!--LYCOS Searchbox start-->
		<script language="javascript">
var uri = 'http://impgb.tradedoubler.com/imp/js/15340/656491?' + new String (Math.random()).substring (2, 11);
document.write('<sc'+'ript language="JavaScript" src="'+uri+'" charset="ISO-8859-1"></sc'+'ript>');
</script>
<!--LYCOS Searchbox end-->
	<td width="3"> &nbsp; &nbsp;</td>
  </tr>
</table>

          </td>
        </tr>
        <tr> 
          <td width="10%">&nbsp; </td>
          <td width="79%"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0" align="left" >
              <tr> 
                <td  colspan="3" class="cmCSS1" align="center"> 
                  <p><br>
                    <font color="#003366" size="5" face="Maiandra GD">Friends 
                    of ST ANDREW'S<br>Cards</font><br><br>
                  </p>
                </td>
              </tr>
              <tr> 
                <td width="0%" height="109">&nbsp;</td>
                <td width="51%"  align="center" valign="top" > 
                  <table width="85%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="default.shtml"  class="cmCSSLink">About 
                        the Friends</a></font></td>
                    </tr>
                    <tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Membership.shtml"  class="cmCSSLink">Membership</a></font></td>
                    </tr>
                    
					<tr>
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Events.shtml"  class="cmCSSLink">Events</a></font></td>
                    </tr>
					
                    <tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Projects.shtml"  class="cmCSSLink">Projects</a></font></td>
                    </tr>
					
					<!--
                    <tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="AGM2004.shtml"  class="cmCSSLink">AGM 2004 - Secretary's Report</a></font></td>
                    </tr>
					-->
					
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0005.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 1</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0006.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 2</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0007.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 3</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0008.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 4</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0009.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 5</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0010.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 6</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0011.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 7</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="Docs/Friends2008News0012.pdf" target="_blank"  class="cmCSSLink">Newsletter 2008 Page 8</a></font></td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" >&nbsp;</td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle">&nbsp;</td>
                    </tr>
					<tr> 
                      <td align="center" valign="middle" ><font size="5" color="#990000">*</font></td>
                      <td>&nbsp;</td>
                      <td align="left" valign="middle"><font face="Maiandra GD" size="3"><a href="/Standrews/default.shtml"  class="cmCSSLink">St. Andrew's Chew Magna</a></font></td>
                    </tr>
                  </table>
</td>
                <td width="49%" height="109" class="cmCSS1" valign="top" align="right" > 
                  <p ><img src="../images/FriendsStAInside.jpg"><br><font color="#888888" size="1"><i>&copy; 
                    Charles Hallsworth</i></font></p>
                </td>
              </tr>
              <tr> 
                <td colspan="3" align="center">&nbsp;</td>
              </tr>
            </table>
          </td>
          <td width="10%">&nbsp;</td>
        </tr>
        <tr> 
          <td width="10%" align="center">&nbsp; </td>
          <td width="79%" align="center" class="cmCSSFSTA"> 
            <p><br>
              &nbsp; <font size="5" face="Copperplate Gothic Bold, Comic Sans MS, Garamond"><b>Exclusive 
              Cards </b> </font></p>
           
            <table width="100%" border="0" cellspacing="3" cellpadding="0">
              <tr align="left" valign="top"> 
                <td width="44%">&nbsp;</td>
                <td width="54%">&nbsp;</td>
                <td width="2%">&nbsp;</td>
              </tr>
              <tr align="left" valign="top"> 
                <td width="44%"> 
                  <p><br>
                    These cards have been specially created for the Friends, available 
                    in packs of 10 at the special Friends price of &pound;5.</p>
                  <p>Approx. 15cm(6&quot;)x11cm(4&quot;)</p>
                  <p>Available from Richard Brown or now in the Church.</p>
                </td>
                <td align="center" width="54%"> 
                  <p><img src="../images/FoStACards.gif" width="283" height="199"></p>
                  <p>&nbsp;</p>
                  <p>Orders to - <a href='javascript:bid("196 104 272 95 198 276 300 300 184 202 198 276 104 95 26 300 4 99 168 95 26 318 202 82 

198 202 271 272 198 196 133 156 300 127 98 270 95 99 184 30 126 104 272 95 198 276 300 32 133 196 32 228 184 271 

32 296 198 276 104 95 26 300 32 152 198 328 127 272 104 231",341,43)' class="cmCSSFSTALink"> 
                    email: Richard Brown</a> or telephone 01275 332348</p>
                </td>
                <td width="2%">&nbsp;</td>
              </tr>
            </table>
            <p ><img src="../images/FriendsofStAndrewsWhiteSmal.jpg" ></p>
          </td>
          <td width="10%"></td>
        </tr>
        <tr> 
          <td width="10%" align="center">&nbsp; </td>
          <td width="79%" align="left" class="cmCSS1">&nbsp;</td>
          <td width="10%"></td>
        </tr>
        <tr> 
          <td width="10%" align="center">&nbsp; </td>
          <td width="79%" align="left" class="cmCSSMenu">&nbsp; </td>
          <td width="10%"></td>
        </tr>
        <tr> 
          <td width="10%" align="center">&nbsp; </td>
          <td width="79%" align="center" >&nbsp;</td>
          <td width="10%"></td>
        </tr>
        <tr> 
          <td width="10%">&nbsp;</td>
          <td width="79%" align="center" class="cmCSSMenu"> 
            
<link rel="stylesheet" href="cmCSS.css" type="text/css">
<script language=javascript src=emailProtector.js></script>
<script language=javascript>
if(!addresses) var addresses = new Array();
addresses.push("4633 2987 2422 4605 4008 4169 4208 896 526 2002 3678 1775 1329 2034 2696 2002 3678 1775 3380 2422 4605 3972 1329 4605 43 2002 896 43 3228 1931");
</script>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><hr>
</td>
</tr>
  <tr> 
    <td width="125">&nbsp;<!--<script language="JavaScript1.2" src="http://www.altavista.com/r?entr"></script>-->
<a href="http://www.w3.org/WAI/WCAG1A-Conformance"  >
  <img height="32" width="88" 
          src="/images/wcag1A.gif"
          alt="Level A conformance icon, 
          W3C-WAI Web Content Accessibility Guidelines 1.0" border="0"></a>

</td><td>&nbsp;</td>
    <td bgcolor="#FFFFFF" width="95%">
      <div align="center" > <font size="1" class="cmCSS1"> <a href="/Sponsors.asp" class="cmCSSLinkSmallEmail"><font size="3">Visit 
        our Sponsors</font><br>
        </a>
		<br>
        &nbsp;Managed by and copyright of <a href="http://www.abitas.com" class="cmCSSLinkSmall">Abitas 
        Ltd</a> based in the UK. <br>
        <br>
		All content, photographic material, art work and design on this site are covered by copyright, please ask permission if you wish to use or purchase copies of material for any purpose commercial or private.<br><br>
        <A HREF='javascript:cost("349 125 70 249 289 323 125 153 228 129 125 289 238 176 111 131 211 289 105 153 204 249 176 129 338 349 125 70 249 289 241 399 249 350 105 249 289 129 241 129 111 241 21 153 228 129 125 289",407,103)' class="cmCSSLinkSmall">Click to email chewmagna</a></font></div>
    </td>
    <td>&nbsp;</td>
	<td>
			<!--LYCOS Searchbox start-->
			<!--
<table width=150 height=50 cellpadding=0 cellspacing=0 border=0 style="background: url(http://www.lycos.co.uk/graphics/search/searchbox/chalk150x50.gif) no-repeat;">
<tr height=1>
<td width=5></td>
<td width=102></td>
<td width=43></td>
</tr>
<tr height=22>
<td></td>
<td colspan=2 valign=bottom>
    <img src="http://www.lycos.co.uk/graphics/search/searchbox/lycossearch97x16.gif" alt="LYCOS" name="LYCOS Search" id="LYCOS Search" width="97" height="16" border="0" hspace=2></td>
</tr>
<tr height=28>
<td></td>
<form method="post" name="mainform" action="http://tracker.tradedoubler.com/click?p=3227&a=656491&g=15565&url=http://search.lycos.co.uk/cgi-bin/pursuit" target="_blank">
<input type="hidden" name="td_matchmode" value="and">
<input type="hidden" name="td_mtemp" value="main">
<input type="hidden" name="td_etemp" value="error">
<td valign=top>
<input style="width: 100px; font: normal 12px 'Trebuchet MS'; height: 20px;" type="text" name="td_query" id="querystring">
</td>
<td valign=top align=left><input type="submit" name="Go" value="Go" 
 img src="http://www.lycos.co.uk/graphics/buttons/login_btn.gif" alt="go" border=0>
</form></td></tr>
</table>-->
<!--LYCOS Searchbox end-->
<!-- <script language="JavaScript1.2" src="http://www.altavista.com/r?entr"></script> -->
	</td>
  </tr>
</table>
<p class="cmCSSLinkSmall">&nbsp;</p>


          </td>
          <td width="10%">&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td height="25" colspan="4" >&nbsp;</td>
  </tr>
</table>
</body>
</html>