<%@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 = "" %> <% ' *** Redirect if username exists MM_flag="MM_insert" If (CStr(Request(MM_flag)) <> "") Then MM_dupKeyRedirect="error1.asp" MM_rsKeyConnection=MM_agropecuaria_STRING MM_dupKeyUsernameValue = CStr(Request.Form("email")) MM_dupKeySQL="SELECT email FROM dbo.organizadores WHERE email='" & MM_dupKeyUsernameValue & "'" MM_adodbRecordset="ADODB.Recordset" set MM_rsKey=Server.CreateObject(MM_adodbRecordset) MM_rsKey.ActiveConnection=MM_rsKeyConnection MM_rsKey.Source=MM_dupKeySQL MM_rsKey.CursorType=0 MM_rsKey.CursorLocation=2 MM_rsKey.LockType=3 MM_rsKey.Open If Not MM_rsKey.EOF Or Not MM_rsKey.BOF Then ' the username was found - can not add the requested username MM_qsChar = "?" If (InStr(1,MM_dupKeyRedirect,"?") >= 1) Then MM_qsChar = "&" MM_dupKeyRedirect = MM_dupKeyRedirect & MM_qsChar & "requsername=" & MM_dupKeyUsernameValue Response.Redirect(MM_dupKeyRedirect) End If MM_rsKey.Close End If %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_agropecuaria_STRING MM_editTable = "dbo.organizadores" MM_editRedirectUrl = "gracias.asp" MM_fieldsStr = "nombre|value|cedula|value|direccion|value|telefono|value|email|value|password|value" MM_columnsStr = "nombre|',none,''|cedula|',none,''|direccion|',none,''|telefono|',none,''|email|',none,''|password|',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 categoriaventas Dim categoriaventas_numRows Set categoriaventas = Server.CreateObject("ADODB.Recordset") categoriaventas.ActiveConnection = MM_agropecuaria_STRING categoriaventas.Source = "SELECT * FROM dbo.categoriaventas ORDER BY categoria ASC" categoriaventas.CursorType = 0 categoriaventas.CursorLocation = 2 categoriaventas.LockType = 1 categoriaventas.Open() categoriaventas_numRows = 0 %> <% Dim categoriadirectorio Dim categoriadirectorio_numRows Set categoriadirectorio = Server.CreateObject("ADODB.Recordset") categoriadirectorio.ActiveConnection = MM_agropecuaria_STRING categoriadirectorio.Source = "SELECT * FROM dbo.categoriadirectorio ORDER BY categoria ASC" categoriadirectorio.CursorType = 0 categoriadirectorio.CursorLocation = 2 categoriadirectorio.LockType = 1 categoriadirectorio.Open() categoriadirectorio_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 categoriaventas_numRows = categoriaventas_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 categoriadirectorio_numRows = categoriadirectorio_numRows + Repeat2__numRows %> miagropecuaria.com :: BIENVENIDOS ::
------------------------------------------------------------------------------------------------------------------------------------------------------------
Western  
 Noticias
Eventos
Registro Organizador
Clave Organizador
<% While ((Repeat1__numRows <> 0) AND (NOT categoriaventas.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 categoriaventas.MoveNext() Wend %>
 " class="linkmarron"><%=(categoriaventas.Fields.Item("categoria").Value)%>
  Publicar Aviso
  Anuncios de Compras
  Publicar Aviso
<% While ((Repeat2__numRows <> 0) AND (NOT categoriadirectorio.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 categoriadirectorio.MoveNext() Wend %>
  " class="linkmarron"><%=(categoriadirectorio.Fields.Item("categoria").Value)%>
   Búsqueda Avanzada
   Registrar en Directorio
  Ventas Online
  Calendario de Eventos
  Foro de Discusión
  Links
  Noticias
  Publicaciones
  Descargables
Registro de Organizador

Gracias por seleccionar nuestro Sistema de Registro de Eventos. Por favor llene el siguiente formulario con todos los datos indicados. Si Ud. ya es usuario registrado haga clic aqui.

Todos los campos son obligatorios

Nombre del Organizador:
Cédula:
Dirección:
Telefono:
Email:
Password:
Repetir Password:
   
 

 
Western  
 Noticias
Eventos
Registro
Contactos
Usuarios
------------------------------------------------------------------------------------------------------------------------------------------------------------
Ayuda | Mapa web | Información general | Publicidad | Condiciones Legales | Información Corporativa
© copyright: Miagropecuaria.com

<% categoriaventas.Close() Set categoriaventas = Nothing %> <% categoriadirectorio.Close() Set categoriadirectorio = Nothing %>