when i was trying my sql stmt at the sql query analyzer, it show the outcome that i want but when i try to put the code into the program it din work out..
below is the error: Error Type: Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
y isit so?? isit becos my code cannot support the sql stmt?
How long did the query take in query analyser. You can use the profiler to see if the asp page is actually contacting the server and trying to execute the query.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
sql query analyzer
Forum Locked
Posted - 05/04/2004 : 23:01:27
