Skip to main content
A
Ajit4176
Participant
October 13, 2010
Question

Same query retrieving different count

  • October 13, 2010
  • 2 replies
  • 614 views

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

This topic has been closed for replies.

2 replies

S
Swift
Inspiring
December 16, 2010

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

D
Dan_Bracuk
Inspiring
October 13, 2010

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?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices