Prblem with Script Time out

[arunbalait]

Hi

I have developed an workbench for my office. That workbench is for data entry.
So each and everytime a person submitting a record a trigger has ben called and their name, workbench name and the datetime.

So for each and everytime a record vl inserted.

So there are 3 to 4 workbenches. All of them follows the same procedure
What I want is I have to take a report that how much records a person doing for a day. The respective count shud be displayed like

Here I have given a Textbox for entering date and a button to Submit
So when I click the submit button the output should be in the format

User Name Workbench Date Total Records

I have tried this query

select convert(varchar(10),dt,105)'My Date' from empreport where convert(varchar(10),dt,105)='20-12-2007'

It works fine if I give the query directly in SQL Server

But If I use this query in ASP it showing Script Timeout error.

I have changed the timeout to the maximum value

rs.open "select userid,convert(varchar(10),dt,105) from empreport where convert(varchar(10),dt,105)='20-12-2007' order by userid",con

rs1.open "select workbench from empreport where convert(varchar(10),dt,105)='20-12-2007' and userid='" & user & "'",con

The above are queries I have tried. Instead giving textbox name I have entered the date directly....

Whats the problem here?

Am stuck with it.. Help me plz

Thanx

Shall I post the full code??

[jhardman]

I don't see any problems in the code you posted. I usually find that I get script timeout errors not with things taking too long, but with infinite loops. Are there any loops on the script? You can check to see if this is the problem by changing it (temporarily, until you find a better fix) to a numbered loop (for x = 1 to 4 ... next) and it should work. Let me know if this helps.

Jared