cfquery not returning correct results

I have a process where I am pulling records from another database.  I put them in the my database and then update a flag in the record from the database so I don't pull it again.  I started noticing that the flag in the records stopped updating.  Now I can't select values from the source table at all.  If I run the query in sql enterprise manager, I get records, but I don't using cfquery.  I am using cfmx 7 version 7,0,1,116466