Re: Sinister variable caching problem with rand()

2010-05-15 Thread Anthony Esposito
PS. I had to strengthen the srand() function I added to the startup.pl that Cosimo suggested. I used the example from the perldoc and have not had any duplicate keys so far. I was having upwards of 3 per 1000 when using srand(time ^ $$) Fix added to startup.pl file ---

Re: Sinister variable caching problem with rand()

2010-05-15 Thread Anthony Esposito
about it and generate completely unique keys. When a line is added in one database it is advertised to all others, the linking between lines in diff tables is easier this way too. Thanks a ton gentlemen, you have saved me a great deal of time. Anthony Esposito On Sat, May 15, 2010 at 1:03 PM, Anthony

Sinister variable caching problem with rand()

2010-05-15 Thread Anthony Esposito
In one of my programs I started to receive database errors for not having a unique id. I generate unique ids for each of the mysql lines that I add to the database. I realized that the perl variable $idNum was keeping the same random string for multiple executions. I created a test program to demo