Same query retrieving different count

[Ajit4176]

In my application I have done a cfdump of a query. The query basically returns 2 columns which are a count based on certain conditons.  The strange part is that for one user the query returns 1& 0 for column A& B where as the same query when executed for another user returns value 0&1 for column A&B respectively. I matched the output in the cfdump and both the queries are identical. The difference in result is what's bothering

Please advise what could have gone wrong.

Rgds

Aj

[Dan_Bracuk]

Verify that both users are using the same db.

Veriffy that the data did not change.

What do you get when you run the query outside of cold fusion?

[Swift]

Aj,

If the query is indeed the same, then perhaps the output code is the culprit? Perhaps show us the query itself and any code that acts on that query, and then the output code itself. If all of that appears correct, then Dan will likely have hit on the answer, which is that the data has changed in some way, or it's not hitting the same database somehow.

Swift