Pccomm - Soluciones que dan confianza <% If Request.QueryString("nombre") <> "" Then set cnn = Server.CreateObject("ADODB.Connection") cnn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("pccomm.mdb") set rst = Server.CreateObject("ADODB.RecordSet") rst.Open "SELECT * FROM comentarios",cnn,3,3 con = Request.QueryString("nombre") mai = Request.QueryString("correo") Come = Request.QueryString("Com") rst.addNew rst("Nombre") = con rst("fecha") = Date() rst("Hora") = Time() rst("Comentario") = Come rst("Sesion") = Session.SessionID rst("NotID") = Request.QueryString("NotID") rst("CookieID") = Request.Cookies("ClientID") rst.Update rst.Close cnn.close %> <% HTML = "Tienes un nuevo comentario en noticias

" HTML = HTML & con HTML = HTML & "

Te dejo un comentario en:
" HTML = HTML & "" HTML = HTML & "La noticia " HTML = HTML & Request.QueryString("NotID") HTML = HTML & "

A las: " HTML = HTML & Now() Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = "smtp.igu.net.mx" .Item(cdoSMTPAuthenticate) = 1 .Item(cdoSendUsername) = "ventaspccomm" .Item(cdoSendPassword) = "2424" .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "ventas@pccomm.com" .To = "rafatabares@gmail.com" .Subject = "Nuevo comentario En noticias" .HTMLBody = HTML .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing Else End IF %> <% set cnn = Server.CreateObject("ADODB.Connection") cnn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("pccomm.mdb") set rst = Server.CreateObject("ADODB.RecordSet") rst.Open "SELECT * FROM contpagina",cnn,3,3 fecha= now() rst.addNew rst("CookieID") = Request.Cookies("ClientID") rst("Dia") = Day(fecha) rst("Mes") = Month(fecha) rst("Agno") = Year(fecha) rst("Hora") = Time() rst("Sesion") = Session.SessionID rst("Dedonde") = Request.ServerVariables("HTTP_REFERER") rst("HitPage") = Request.ServerVariables("PATH_INFO") rst.Update rst.Close cnn.close %>

Home

Nosotros

Servicios

Noticias

Reportes

Medical

Contacto

 
Google
<% set cnn = Server.CreateObject("ADODB.Connection") cnn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("pccomm.mdb") set rst = Server.CreateObject("ADODB.RecordSet") rst.Open "SELECT * FROM noticias",cnn,3,3 Chingadera = Request.QueryString("NotID") Chingadera = CLng(Chingadera) IF Request.QueryString("NotID") = "" THEN rst.Movelast ELSE rst.filter = "NotId = ' "& Request.querystring("NotID") & " ' " END IF %>
<%= rst("Titulo") %>
Fecha: <%= rst("Fecha") %>

" align="left"><%= rst("Noticia") %>

<%= rst("Autor") %>  @ <%= rst("Hora") %> |  <% Notide = rst("Notid") rst.Filter = 0 rst.Movelast Cadena = Clng(Request.QueryString("NotID")) Tabla = Clng(rst("Notid")) IF ((Cadena = Tabla) OR (Request.QueryString("NotID") = "")) Then rst.Moveprevious Notid1 = rst("Notid") Titulo1 = rst("Titulo") rst.Moveprevious Else Notid1 = rst("Notid") Titulo1 = rst("Titulo") rst.Moveprevious End IF Cadena = Clng(Request.QueryString("NotID")) Tabla = Clng(rst("Notid")) IF (Cadena = Tabla) Then rst.Moveprevious Notid2 = rst("Notid") Titulo2 = rst("Titulo") rst.Moveprevious Else Notid2 = rst("Notid") Titulo2 = rst("Titulo") rst.Moveprevious End IF Cadena = Clng(Request.QueryString("NotID")) Tabla = Clng(rst("Notid")) IF (Cadena = Tabla) Then rst.Moveprevious Notid3 = rst("Notid") Titulo3 = rst("Titulo") rst.Moveprevious Else Notid3 = rst("Notid") Titulo3 = rst("Titulo") rst.Moveprevious End IF rst.Close cnn.close %> <% set cnn = Server.CreateObject("ADODB.Connection") cnn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("pccomm.mdb") set rst = Server.CreateObject("ADODB.RecordSet") rst.Open "SELECT * FROM comentarios",cnn,3,3 rst.Filter="Notid= '" & Notide & "'" Conta = 0 Do until rst.Eof Conta = Conta + 1 rst.Movenext LOOP %> Comentarios (<%= Conta %>)  |  + Aņade tus comentarios



<% If (Eof = True) Or (Bof = true) Then rst.Moveprevious Else End IF%> <% Do until rst.Bof%> <%= rst("Nombre") %>
<%= rst("fecha") %> @ <%= rst("hora") %>

<%= rst("Comentario") %> <% rst.Moveprevious %>
<% LOOP rst.Close cnn.close %>

Aņade tus comentarios:
Nombre:
Comentarios:

  


Noticias anteriores:
<% IF Notid1 <> "" Then %> <%= Titulo1 %>
<% Else END IF IF Notid2 <> "" Then %> <%= Titulo2 %>
<% Else END IF IF Notid3 <> "" Then %> <%= Titulo3 %>
<% Else END IF %> [+]Noticias...

COMUNICACIONES VIA PC
TEL Y FAX (0133) 36-09-16-35 , 36-37-51-34
NEXTEL 166774 *1
MSN: noeltaba@hotmail.com