Perl and DBI

[bri4518]

First let my just say I am a Sys Admin not a programmer.
I have a perl script I am using for a time clock program and it is sort of working. It does half the select and update statments without a problem, but one in particular acts goofy. It is when an employee goes on break they go through the menu steps, and at the end it does not update the database for that current user but for a user I was trying like 7-8 times before to test it. Why would it be perfomring a step from the time before like this even after I close the script and computer, and where is this information stored at that it uses.

perl
DBI module
SQL database

Thanks for you help,
Brian

 

[KevinADC]

Well, I would have to assume the problem is in the perl code. Since we can't see the code, can't really say what the problem might be. Look through the code very carefully, look at the user that is being updated incorrectly and work backwards (logically speaking) to see if you can determine where this mis-match is occuring. Does the perl script make use of:

use strict;
use warnings;

these pragmas can help trace hard to find bugs

------------------------------------------
- Kevin, perl coder unexceptional!

 

[bri4518]

thanks for the reply.
I am using strict and warnings.
i dropped the table i was updating from the database
i then recreated it with the same create table script i used to originally create it
and now everything works great...so i had something twisted up

 

[KevinADC]

OK....

------------------------------------------
- Kevin, perl coder unexceptional!