Tuesday, November 27, 2001

Phone 2 in Surrey Police
Difference Report
Project: $/Phone2
Working Folder: F:\SOURCE\WEB\PHONE2

Modified:
global.asa
Details/AdminMainInclude.asp
Details/PhoneInc.asp
Details/PhoneListAmend.asp
Details/PhoneListEditor.asp
DistributionList/DistributionListAdmin.asp
DistributionList/DistributionListEditor.asp
DistributionList/ShowMembers.asp
Images/internal directory 01.gif
Init/AdminMain.asp
LocationAdmin/LocationPick.asp
Search/PHONEResult.asp
Search/PhoneSrc.asp
TitleAdmin/TitlePick.asp
XML/LocationXML.asp


Looking at Wayne's problem from last Wednesday:
Loaded the new PhoneListAmend.asp page. Added a new user clicked save, screen stayed the same although the info frame said the record had been added successfully. Looked in the database and the record was added although the PHN_Title was blank and the PHN_LocationID contained 0. Also the PHN_ModBy field contains the value -1.

When searching for any user I get a runtime error, I have attached the error and debugging screen into a word document. If you click on no the details appear. If I search for the user I just added I do not get any results back even though they are in the database.


Michael said:
> Now about the main Search Result. In this page, the querying is done
> on Locations table also unlike in the search under the Admin tab. The
> difference in result was caused because of some junk data. For eg. A
> search for Surname like "%Test%" returns only 2 in main Search page
> because 2 records have LocationID as 1 & there is no corresponding
> record in the Location table. In Surrey, the problem will be solved when
> the LocationPick.asp page is replaced. The previous version of that page
> was not passing the LocationID properly while adding a User.


No comments: