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?