About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
The data that is retrieved from the Recorset is very little. I am Printing an invitation for all Students to attend a function in University and the data that is retrieved from the database is only the name of the Student and Address all the rest is the Same text that is being printed for all letters I think because of this large text that is getting printed I get Script Timeout Error.
Now I think you can understand my problem much better.
-------------------------------------------
The text above is a follow-up to ...
-----Question-----
Hi,
I have changed the ScriptTimeout to 300 even then I get ScriptTimeOut Error this is because a large amount of text is getting printed for each and every Recordset. My program generates a Letter to all the parties so I have to print a default text for all the Letters the total Number Of letters that gets printed is 6500. what can be done to Overcome this error.
Please help me Out.
Regards,
Aarthy.K
-------------------------------------------
The text above is a follow-up to ...
-----Question-----
Hi,
I am Using a ASP Page which retrives 5000 records from the Database and prints it along with some text.One Record per page.The time taken to execute the query is just 5sec when I call it in the Asp page without any text then it works fine but when the text is included it ends up with Script Timeout error.
Can you help me with this error.
Regards,
Aarthy
-----Answer-----
Without seeing the code itself thatgenerates the recordset and the timeout error I would have to say no. The only thing I have questions about is if the text that is being added is timing the script out. Is it thesame text for every record or is it thevalueofsome text filed within the recordset itself?
Have you tried setting the server level application variable for scripttimeout to some other time?
It works like this:
IIS by default sets script time out at 90 seconds so if you set script timeout for less than this the setting is ignored. You can set a different timeout by doing the following:
<%
Server.ScriptTimeout = 100 'or some other number greater than 90
%>
This then tells the server to not timeout the script until 100 seconds haspassed. So, the numeric value you apply to this setting is the number of seconds you want to wait before the script times out.
-----Answer-----
So every time you run this thing you're printing 6500 letters?
Have you tried breaking the recordset up into smaller segments?
Answer Try this:
Dump the record set into an array such as this:
function create_array(sql, elements, byref data_fm)
' response.write sql
set ors = oconn.execute(sql)
counter = 0
while not ors.eof
counter = counter + 1
redim preserve data_fm(elements, counter)
for asdf = 1 to elements
data_fm(asdf,counter) = ors(asdf-1)
next
ors.movenext
wend
set ors = nothing
create_array = counter
end function
