<%@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
<

  Home
  News
  Committees
  Football
  Fixtures
  History
  Gallery
  Policies
  Documents
  Merchandise
  Monthly Draw Winners
  Coaches
  Youth Section

 

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

 

Doire Colmcille Youth Pages
Welcome to the home page of Doire Colmcille Youth section. Please use the navigation sections to find the appropriate team page. If you would liket to add anything to the site or suggest any improvements please contact doirecolmcille@gmail.com
Under 18 Section

Under 16 Section

Under 14 Section

Under 12 Section

Under 10 Section

Under 8 Section

Nursery Section

family


Please visit our Club Sponsors

Mc Cartney and Casey

NEWS (all news) 

Senior mens training resumes Thursday 21st Jan 2010 at City of Derry Rugby Club. 7pm start

Underage training resumes Tuesday 19th January St Columbs College and on Saturday mornings at 10.30


 
  NEWS.asp