Hola mi pagina me aroja estyo cuando quiero sacar unos datos de la base de datos :(
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:
Ver original<% 'Response.Buffer = false
Server.ScriptTimeout = 9000
%>
y en elc uerpo:
Código ASP:
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
%>
vosotros sabeis que podra ser?