Hello All,
I have a script that querries a database table, gets the data, formats it, and places it in txt files that are sent of as attachments.
The script works - sort of.
Randomly, there is data missing from the txt files. Lets say the end result looks something like this:
15-12-2002;108;65;26156;3245;45
for no apparent reason, and randomly, the result will have bits missong like this:
15-12-2002;108;
The script is scheduled with cron. I am quite sure that the querries themselves are not to blame. It seems to be in the formatting part. Is it possible that the script runs too fast? Could I put in a sleep statement? Any thoughts or ideas most welcome.
I have a script that querries a database table, gets the data, formats it, and places it in txt files that are sent of as attachments.
The script works - sort of.
Randomly, there is data missing from the txt files. Lets say the end result looks something like this:
15-12-2002;108;65;26156;3245;45
for no apparent reason, and randomly, the result will have bits missong like this:
15-12-2002;108;
The script is scheduled with cron. I am quite sure that the querries themselves are not to blame. It seems to be in the formatting part. Is it possible that the script runs too fast? Could I put in a sleep statement? Any thoughts or ideas most welcome.