Before my question, I am obliged to say:

"GO CANADA! GO! ... WE ARE THE BEST HOCKEY PLAYERS ON EARTH BABY!!!"

ok, now that that's out of the way.

Is there a way to return a record count for a given table whithout
performing a query? To clarify:

here's what I do now:

<CFQUERY name="name" datasource="datasource">
SELECT  ID
FROM    tblFoo

</CFQUERY>

Then I can use #name.recordcount#. But I never use the ID for anything, the
sole purpose of that query is to get a record count. This strikes me as
inefficient. Any suggestions?

Thanks in advance.

-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Bill Sourour" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to