Phone 2 in Surrey Police
Working Folder: F:\SOURCE\WEB\PHONE2
Images/internal directory 01.gif
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.
> 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.