Symptoms: Server side code seems to be working up to the point that this particular asp command object “execute” is invoked. The stored procedure does not return any value and the rest of the VBScript code is aborted. However the HTML page is rendered, and one data fetch that did work populates a dropdown list properly.

Circumstances: I made an *exact* copy of an existing, working web site. I am restructuring some of the pages. On the page in question certain SQL (or the ASP objects) are no longer working – despite the fact that the specific ASP code is exactly the same. The difference is the application of the structured programming technique to reorganize the code. Yes, I know this introduces scope issues.

In the non-working case I have verified that execution enters the recordLock subroutine, the ASP command object is built, parameters are created and populated with the same values as in the working version. I have verified, via query analyzer tool, that the stored procedure works given these same parameter values. But execution does not seem to happen, or it aborts in mid-stream, in the context of this new, structured code.

Environment:
Client: Windows 98 w/ internet explorer 5.5
Server: IIS 4.0
Database: MS SQL server 2000 (version?).

NOTE: both web sites work against the same database. The database is not a mirror / duplicate.

Code snippet available if you need to see it
Thanks
Dorris