Solved

Length of a resultset

Posted on 2004-09-26
2
295 Views
Last Modified: 2013-12-24
Does anybody know how to get the number of rows returned by a cfquery?
0
Comment
Question by:leeandron
  • 2
2 Comments
 
LVL 21

Accepted Solution

by:
pinaldave earned 250 total points
ID: 12156067
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
 
LVL 21

Expert Comment

by:pinaldave
ID: 12156381
glad to help you,
Have a good day!
---Pinal
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now