Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Length of a resultset

Does anybody know how to get the number of rows returned by a cfquery?
0
leeandron
Asked:
leeandron
  • 2
1 Solution
 
pinaldaveCommented:
if your query name is <cfquery = "queryname" datasource="dsn">


in that case following variable will return the number of the rows : #queryname.recordcount#

use # as per your requirements.
Regards,
---Pinal
0
 
pinaldaveCommented:
glad to help you,
Have a good day!
---Pinal
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now