Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Problem with fetching data

Hi,

In my application I am facing problem with one report.

I am creating statistics report for one year. When I click on Hyperlink for the first time I am getting blank page.

From ASP page i am calling delphi function. From delphi function I am calling Stored procedure which is written in SQL server. SP returns the data in XML format.

When I execute stored procedure from Query analyzer I could see the data is fetching properly. But From front end, ASP page I am not able to see the data.

For this report I am fetching data from multiple tables and each table contains morethan 20 lacs record. I tried to fetch the data only for few months. then I am able to see the report properly.

I have set script time out to 3600 sec.

Could anybody help me in resolving this issue
[845 byte] By [madhulatha_b] at [2007-11-11 9:59:04]