<%@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 & "?" & 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")) = "form1") Then MM_editConnection = MM_connMaster_STRING MM_editTable = "users" MM_editRedirectUrl = "afiliacion_gracias.asp" MM_fieldsStr = "ApellidoPaterno|value|ApellidoMaterno|value|Nombre|value|FechaNacimiento|value|Email|value|Calle|value|Colonia|value|Ciudad|value|Estado|value|Pais|value|Telefono|value|TelefonoMovil|value|CodPostal|value|Nivel|value|Escuela|value|Otros|value|Comentarios|value|id_tipo_evento|value|id_evento|value" MM_columnsStr = "ApellidoPaterno|',none,''|ApellidoMaterno|',none,''|Nombre|',none,''|FechaNacimiento|',none,NULL|Email|',none,''|Calle|',none,''|Colonia|',none,''|Ciudad|',none,''|Estado|',none,''|Pais|none,none,NULL|Telefono|',none,''|TelefonoMovil|',none,''|CodPostal|',none,''|Nivel|none,none,NULL|Escuela|',none,''|Otros|',none,''|Comentarios|',none,''|id_tipo_evento|none,none,NULL|id_evento|none,none,NULL" 'MM_fieldsStr = "ApellidoPaterno|value|ApellidoMaterno|value|Nombre|value|FechaNacimiento|value|Email|value|Calle|value|Colonia|value|Ciudad|value|Estado|value|Pais|value|Telefono|value|TelefonoMovil|value|CodPostal|value|TradJapones|value|Tibetantrico|value|Karuna|value|Usui_Tradicional|value|NeoOsoho|value|Nivel|value|Escuela|value|Aromaterapia|value|Taichi|value|Polaridad|value|PolaridadP|value|Flores|value|Cromoterapia|value|Shamanismo|value|Otros|value|Comentarios|value|id_tipo_evento|value|id_evento|value" 'MM_columnsStr = "ApellidoPaterno|',none,''|ApellidoMaterno|',none,''|Nombre|',none,''|FechaNacimiento|',none,NULL|Email|',none,''|Calle|',none,''|Colonia|',none,''|Ciudad|',none,''|Estado|',none,''|Pais|none,none,NULL|Telefono|',none,''|TelefonoMovil|',none,''|CodPostal|',none,''|TradJapones|none,1,0|Tibetantrico|none,1,0|Karuna|none,1,0|[Usui Tradicional]|none,1,0|NeoOsoho|none,1,0|Nivel|none,none,NULL|Escuela|',none,''|Aromaterapia|none,1,0|Taichi|none,1,0|Polaridad|none,1,0|PolaridadP|none,1,0|Flores|none,1,0|Cromoterapia|none,1,0|Shamanismo|none,1,0|Otros|',none,''|Comentarios|',none,''|id_tipo_evento|none,none,NULL|id_evento|none,none,NULL" ' 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 dim sSQL, IdUser dim oRc : set oRc = Server.CreateObject("ADODB.RECORDSET") sSQL = "SELECT MAX(IdUser) FROM users" oRc.ActiveConnection = MM_editConnection orc.Source = sSQL oRc.Open IdUser = oRc(0) orc.Close dim anio : anio = Year(date) dim Cod_User anio = Right(anio, 2) Cod_User = anio & IdUser & "CH" sSQL = "UPDATE users SET Cod_User = '" & Cod_User & "' WHERE IdUser = " & IdUser Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = sSQL MM_editCmd.Execute Session("Cod_User") = Cod_User dim sFrom : sFrom = "info@reikimexico.org" dim sTo : sTo = "info@reikimexico.org" dim sSubject : sSubject = "Gracias por afiliarse al Centro Holístico Latinoamericano A.C. (Alternativa Reiki) sus datos fueron recibidos correctamente." dim sBody : sBody = "Gracias por afiliarse al Centro Holístico Latinoamericano A.C. (Alternativa Reiki) sus datos fueron recibidos correctamente.
" &_ "Su numero de afiliado es: " & Cod_User & "
" &_ "Email de la persona Afiliada: " & Request("Email") call SendMailForm(IdUser) call MandaMail(sFrom, sTo, sSubject, sBody) call MandaMail(sFrom, Request("Email"), sSubject, sBody) If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim rsPais Dim rsPais_numRows Set rsPais = Server.CreateObject("ADODB.Recordset") rsPais.ActiveConnection = MM_connMaster_STRING rsPais.Source = "SELECT * FROM Pais" rsPais.CursorType = 0 rsPais.CursorLocation = 2 rsPais.LockType = 1 rsPais.Open() rsPais_numRows = 0 %> <% Dim rsNivel Dim rsNivel_numRows dim oRcTE : set oRcTE = Server.CreateObject("ADODB.RECORDSET") dim oRcE : set oRcE = Server.CreateObject("ADODB.RECORDSET") Set rsNivel = Server.CreateObject("ADODB.Recordset") rsNivel.ActiveConnection = MM_connMaster_STRING rsNivel.Source = "SELECT * FROM Nivel" rsNivel.CursorType = 0 rsNivel.CursorLocation = 2 rsNivel.LockType = 1 rsNivel.Open() rsNivel_numRows = 0 oRcTE.ActiveConnection = MM_connMaster_STRING oRcTE.Source = "SELECT * FROM tb_tipo_evento ORDER BY nm_tipo_evento" oRcTE.Open oRcE.ActiveConnection = MM_connMaster_STRING oRcE.Source = "SELECT * FROM tb_evento ORDER BY id_tipo_evento, nm_evento" oRcE.Open %> Alternativa Reiki Centro Holístico Latinoamericano S.C.
 
 
Mapa de Ubicación



Afiliación

Ser miembro del Centro Holístico Latinoamericano te da descuentos permanentes en todos nuestros Cursos, Talleres y Diplomados.

Recibe una ¡Terapia Gratis de Reiki!

Los campos señalados con * son obligatorios

* Apellido Paterno:
ejem.López
Apellido Materno:
ejem.Díaz
* Nombre:
ejem.Daniela 2
Fecha de Nacimiento:
ejem.19/01/1978 (dia, mes, año)
* Email
ejem.dany@hotmail.com
Calle
ejem.Tikal #2012
Colonia
ejem.Riviera Maya
* Ciudad
ejem.Merida
Estado
ejem.México D.F.
País
ejem. México
* Teléfono
ejem.01(55)76474683
Telefono Móvil
ejem.044 55
* Código Postal
ejem. 531200
Mi Nivel de Reiki es
ejem.Nivel II
Contacten conmigo por medio
ejem.Teléfono, Email, Carta, Fax
Quiero cursar el
ejem.Diplomado
Selecciona una Opción
ejem.Reiki Tradicional Japonés
Los conoci por medio de
ejem.Periodico, TV, Revista, Internet
Comentarios
 

Home | Quienes Somos| Diplomado Reiki | Cursos |Mikao Usui| Afiliación | Contáctanos
2006© Copyright Centro Holístico Latinoamericano S.C. ®. Politicas de Privacidad - Aviso Legal
<% rsPais.Close() Set rsPais = Nothing %> <% rsNivel.Close() Set rsNivel = Nothing %>