Do a first quesrt using sql count On Jan 26, 2013 12:41 PM, "Rick Faircloth" <r...@whitestonemedia.com> wrote:
> > If I'm running a query on a database > and limit the records returned to 10, > what's the best way to get the record count > for the entire dataset if everything was > return and not just the first 10 records? > > I can re-rerun the query without the 10-record > limit, but that seems like a ridiculous > approach, just to get the record count. > > Suggestions! > > Thanks, > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm