Skip to main content
Participant
March 17, 2008
Question

Query on Query giving less records

  • March 17, 2008
  • 1 reply
  • 401 views
I have a query say A whcih gives me a record set of around 96 records. I have another query B where I select distinct of userid and username from the query A. On the web page when I display from my query B, it get only 3 records. While my debugg mode is On the query which I execute which I get from the debug mode has 8 records in query B. Am not sure why does the web page display only 3 records.
Note: No filter condition is added in query B, its just a select distinct of userid, username from query A.

Please help.

Rgds
This topic has been closed for replies.

1 reply

Inspiring
March 17, 2008
What is your output code? What happens when you cfdump it? What happens when you either output or dump the recordcount?
Ajit4176Author
Participant
March 17, 2008
I was able to resolve it. Thanks for the help.