<%@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
%>
<%
Dim code4
Dim code4_numRows
Set code4 = Server.CreateObject("ADODB.Recordset")
code4.ActiveConnection = MM_maq_STRING
code4.Source = "SELECT ACUNO FROM clientes WHERE IVTYPI=4"
code4.CursorType = 0
code4.CursorLocation = 2
code4.LockType = 1
code4.Open()
code4_numRows = 0
%>
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
while not code4.eof
'
sqlmins="UPDATE PROSPECTOS SET IDMCTE=4 WHERE IDDBSCTE='" +code4("ACUNO")+ "' "
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
MM_editCmd.ActiveConnection.Close
IF ERR THEN response.redirect("es.asp?cmd=" +cstr(len(sqlmins)) )
code4.movenext
wend
Server.ScriptTimeOut =90
response.redirect("code4.asp?success=Archivo " + CSTR(model)+ " Registrado Satisfactoriamente:Registros-"+ cstr(total)+"&totales=" + cstr(ist)+p)
end if
%>
