Viewing: DBMan

DBMan is fully configurable for many applications, has an extensive array of help so that even someone who knows nothing about Perl scripts can modify it to suit their particular requirement and get it to run flawlessly. One problem I encountered was that I allowed the 'key' field to be seen and modified by web visitors. This was an automatically-entered numerical field (user ID) that one visitor decided to fill in on the form. Somehow, I ended up with gaps in my numbering, (perhaps accounts were closed) and the script went back to fill in the missing numbers. When the automatic increment reached the point where the numbers already existed, instead of skipping them and starting at the end of the existing numbers, the script failed to add any more records. To correct the problem, I had to create a new record and manually set the counter to the first available number at the end of series. From that point on, the script again indexed each new record with a new user ID number.