Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

incorrect resultset being returned

 
Joe Wilkinson
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a thread that wakes up every 30 secs and does a call to the database to get the files that are new and need to be processed. We use a mysql database running on win2k. the field that we use as a flag is a tinyint unsigned field. occasionally when the following code is executed it disregards the processed=0 condition, and re-processes files that have already been processed (months ago). the code :

the files_id=0 is used to differentiate whether the file is stored on the HDD or in the database.
Any ideas why this would happen? If we stop the application and restart it it then works properly again. due to its erratic behaviour we don't know how to reproduce it.
Thanks,
Joe
[ Edited by Dave to format code ]
[ January 22, 2003: Message edited by: David O'Meara ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic