Inherited ASP Problem

I am having a problem with an 'inherited' app. The app consists of a form that follows a predetermined path depending upon who it is assigned to. The final email is sent to specific individuals for the final 'approval'. In this stream, each individual who is assigned to get an email (stating that the form is ready to be signed) does. The only exception (and where my problem lies) is the individuals who are supposed to get the final approval email. This app has been in place since the end of 2002 and all of a sudden these individuals are no longer receiving their email. I am also not getting any error message stating there is a problem

View Replies


ADVERTISEMENT

Debugging Inherited Code

I've inherited some code from someone else, and with the move to a new server some problems have arisen. I've spent a while trying to nut them out, but I just can't seem to make progress and I'm hoping a fresh perspective from some other people will help.

First problem:

If you go here you will see a list of Bed and Breakfasts. If you click on "Azimuth Country Estate" (the third one down) you will see an example of a perfectly working setup. It opens in a popup window and everything appears nicely. Now click on "Bilinga Bed and Breakfast" (the fifth one down). You will see that halfway down the page in the popup window there is the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80020009'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/morbobge/popups/standard.asp, line 0

I looked this error up on Google and found that it has to do with Text fields not being the last fields drawn from the database. So I went back to the query and instead of saying "SELECT *" I explicitly selected each field in the database and made sure that the Text fields were last. Sadly this hasn't fixed the problem.

Any suggestions?

Second problem:

If you go here you will find what is supposed to be the events diary. Sadly, it cuts off at Day 1. I haven't been able to work out why.

I haven't posted any code for either of these problems, simply because it is all such a huge rambling mess that I have no idea which bits to post. Instead, I have attached a zip file with the two offending files in it, in the hope that some kind person will take a peep and help me out here

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved