Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/Mes/Asp/was2/show2.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
En la cabecera tengo:
Código ASP:
y en elc uerpo:Ver original
<% 'Response.Buffer = false Server.ScriptTimeout = 9000 %>
Código ASP:
vosotros sabeis que podra ser? Ver original
<% dim conexion,calendar1,calendar2,registros,linea calendar1=request.form("calendar1") calendar2=request.form("calendar2") linea=request.form("linea") Tubo=request.form("tubo") SET conexion=Server.CreateObject("ADODB.Connection") conexion.Open "PROVIDER=SQLOLEDB; DATA SOURCE=VALP-Maple01;UID=sa;PWD=messrv;DATABASE=wasp " SET registros=Server.CreateObject("ADODB.RecordSet") 'registros.open"SELECT peso,tubo from pesos where fecha between '"&calendar1&"' AND '"&calendar2&"'",conexion if linea="1" Then registros.open"SELECT p.peso,p.vaso,p.fecha, o.linea,o.tubo FROM pesos as p, optimas as o where o.codigo = p.codOptima AND o.tubo LIKE '"&tubo&"' AND p.fecha Between '"&calendar1&"' AND '"&calendar2&"'order by fecha",conexion elseif linea="11" then registros.open"SELECT p.peso,p.vaso,p.fecha, o.linea,o.tubo,o.empaque FROM pesos as p, optimas as o where o.codigo = p.codOptima and o.empaque =1 and o.tubo LIKE '%' AND p.fecha Between '"&calendar1&"' AND '"&calendar2&"' order by fecha",conexion else registros.open"SELECT p.peso,p.vaso,p.fecha, o.linea,o.tubo FROM pesos as p, optimas as o where o.codigo = p.codOptima and o.linea = '"&linea&"' and o.tubo LIKE '"&tubo&"' AND p.fecha Between '"&calendar1&"' AND '"&calendar2&"' order by fecha" ,conexion end if do while not registros.eof response.write("<tr>") response.write("<td>"®istros.fields("linea")&"</td>") response.write("<td>"®istros.fields("peso")&"</td>") response.write("<td>"®istros.fields("vaso")&"</td>") response.write("<td>"®istros.fields("tubo")&"</td>") response.write("<td>"®istros.fields("fecha")&"</td>") registros.movenext loop conexion.close 'SELECT p.peso,p.tubo,p.fecha, o.linea FROM pesos as p, optimas as o where o.codigo = p.codOptima and o.linea = 'L02N' AND p.fecha Between '2010-05-11 09:42:34.000' AND '2010-05-11 09:42:39.000' SET conexion2=Server.CreateObject("ADODB.Connection") conexion2.Open "PROVIDER=SQLOLEDB; DATA SOURCE=VALP-MAPLE01;UID=sa;PWD=messrv;DATABASE=wasp " SET registros2=Server.CreateObject("ADODB.RecordSet") registros2.open"SELECT AVG(PESO)as peso from pesos where fecha Between '"&calendar1&"' AND '"&calendar2&"'",conexion2 do while not registros2.eof response.write("Promedio: "®istros2.fields("peso")&"") registros2.movenext loop conexion2.close %>