Depending on your version of CF, try Variables["#TRAK#.RecordCount"] or
Evaluate("#TRAK#.RecordCount")> -----Original Message----- > From: Les Mizzell [mailto:[EMAIL PROTECTED]] > Sent: Friday, 16 August 2002 11:18 a.m. > To: CF-Talk > Subject: How to get RecordCount from a variable query name > > > I'm using a looped query like: > > <cfloop index="TRAK" list="#queryLIST#"> > <cfquery name="#TRAK#" datasource="MyData"> > SELECT * > FROM INT_PROJECT > WHERE TRACK = '#TRAK#' and ARCHIVE = 'No' > ORDER BY ID DESC > </cfquery> > > > While I know how to get the count from a static query name -- > #myQuery.RecordCount# -- I'm not sure how to get the record > count for each > query in the list as it loops through. Obviously > #TRAK#.RecordCount doesn't > work.... > > Suggestions? > > I've been awake way too long, it's probably obvious and my brain has > stopped.... > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
