Nominations for the Clitorides are still open. Nominate your favourites [ X Dismiss ]
Home « Forum « Bug Report and Feature Requests

Forum: Bug Report and Feature Requests

Data Field verification Routine

Ernest Bywater

Not sure if you have a routine on the other fields, but you don't have a data verification routine on With a Score of field in the Search by Category page. Years ago, when i was doing database design and form design for the databases one thing I was taught was to have a routine that checked the data entered in a field was within the acceptable parameters for the field - no letters in a numeric field, only accepts two characters if that's the field size etc. I just accidentally entered 100 as a score to search on, when I meant to enter it a a size, and the damn thing accepted the entry then did a search and told me there were no matches instead of telling me I screwed up. I knew there had to be a match so i checked the entry, and saw my error, but if it had been a first time search I'd have accepted the result as a valid one and not an error by me.

Lazeez Jiddan (Webmaster)

@Ernest Bywater

Fixed it to drop out of range values.

Thanks for the bug report.

Replies:   Ernest Bywater
Ernest Bywater

@Lazeez Jiddan (Webmaster)

you're welcome - I've been there and done all that, got the t-shirt for each time I had to fix a bug, and sold them by the gross later.

Back to Top