Length of a resultset

Does anybody know how to get the number of rows returned by a cfquery?
leeandronAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pinaldaveConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.