DOIRE COLMCILLE CLG - Leading GAA in Derry City

<%@LANGUAGE="VBSCRIPT"%> DOIRE COLMCILLE CLG - Leading GAA in Derry City <% ' *** 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")) = "Subform") Then MM_editConnection = MM_DCC_STRING MM_editTable = "NewsletterSubscribers" MM_editRedirectUrl = "SubThankyou.asp" MM_fieldsStr = "Newsletter|value" MM_columnsStr = "SubEmail|',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 rsInfo Dim rsInfo_numRows Set rsInfo = Server.CreateObject("ADODB.Recordset") rsInfo.ActiveConnection = MM_DCC_STRING rsInfo.Source = "SELECT * FROM DCCRegUpdates ORDER BY NewsDate DESC" rsInfo.CursorType = 0 rsInfo.CursorLocation = 2 rsInfo.LockType = 1 rsInfo.Open() rsInfo_numRows = 0 %> <% Dim SubNewsletters Dim SubNewsletters_numRows Set SubNewsletters = Server.CreateObject("ADODB.Recordset") SubNewsletters.ActiveConnection = MM_DCC_STRING SubNewsletters.Source = "SELECT * FROM NewsletterSubscribers" SubNewsletters.CursorType = 0 SubNewsletters.CursorLocation = 2 SubNewsletters.LockType = 1 SubNewsletters.Open() SubNewsletters_numRows = 0 %>

Contact Doire Colmcille

<

Documents

Merchandise

Monthly Draw Winners

Youth Section

To sign up for the weekly club e-newsletter, enter your email address below:

Doire Colmcille CLG

Welcome to the History section of Doire Colmcille CLGs website.

Doire Colmcille CLG was established in 1969 following the amalgamation of 3 city clubs - Daire Og, Eire Og and Sarsfields. Doire Colmcille was born out of humble beginnings, with only representation being a Men's Senior Football team.

Over the past 40 years Doire Colmcille CLG has continuously grown to serve the local gaelic community, and now is represented by no fewer than 10 individual footballing teams spanning both Men's and Ladies from Under 6 nursery school children right through to Senior mens and Ladies teams. Doire Colmcille CLG is goverened by an elected Executive Committee comprising 11 officers from Chairman right through to Ladies and Men's playing Representatives. All officers are elected by full members at the club's Annual General Meeting.

Doire Colmcille CLG were crowned All County Junior Champions in 1974, and, have played in the Intermediate football ranks for the majority of the Clubs existence.

Doire Colmcille CLG has a rich and proud history, and is committed to providing Gaelic Games to the local community for the next 40 years and more.

Please visit our Club Sponsors

Mc Cartney and Casey

NEWS (all news)

Coaching Section

NEWS.asp

NEWS.asp , <% rsInfo.Close() Set rsInfo = Nothing %> <% SubNewsletters.Close() Set SubNewsletters = Nothing %>