<%@LANGUAGE="VBSCRIPT"%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="ADMIN,GERENTE"
MM_authFailedURL="login.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (false Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
www.promad.com.mx
Alimentar Codigos Cerrados:
a)Pegue el listado de los Codigos Cerrados (Deben estar en
forma columnar, separados por un Enter cada uno.
Presione Actualizar.
<%=REQUEST("success") %>
<%
Server.ScriptTimeOut =270
'on Error response.redirect("inputclient.asp?time=" +cstr(time()) )
if request("upd")<>"" then
Set f = request("configuracion")
'Lectura de Archivo Cargado
vel=split (f,chr(10))
limites=""
deli=""
'ON ERROR RESUME NEXT
thispi=GetIndexNumber()
sqlmins="UPDATE PROSPECTOS SET IDMCTE=0"
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_maq_STRING
MM_editCmd.CommandText = sqlmins
'response.redirect("es2.asp?cmd=" +sqlmins )
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
for i=lbound(vel) to UBOUND(vel)
if vel(i)<>"" then
sqlmins="UPDATE PROSPECTOS SET IDMCTE=4 WHERE IDDBSCTE='" + REPLACE(vel(i),CHR(13),"") + "' "
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_maq_STRING
MM_editCmd.CommandText = sqlmins
total=total+1
'response.redirect("es.asp?cmd=" +sqlmins )
MM_editCmd.Execute
IF ERR THEN response.redirect("es.asp?cmd=" +cstr(len(sqlmins)) )
MM_editCmd.ActiveConnection.Close
end if
next
Server.ScriptTimeOut =90
response.redirect("code4.asp?success=Archivo " + CSTR(model)+ " Registrado Satisfactoriamente:Registros-"+ cstr(total)+"&totales=" + cstr(ist)+p)
end if
%>
