Solved

Length of a resultset

Posted on 2004-09-26
2
299 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

778 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