> 01 <cfloop query="categories">
> 02 <cfset queryName="#column_from_query#">
> 03
> 04 <cfoutput>
> 05
> 06 <cfif "#queryName#.recordcount" gte 1> DO THIS </cfif>
> 07 <cfif "#queryName#.recordcount" lt 1> DO THAT </cfif>
> 08
> 09 </cfoutput>
> 10 </cfloop>
Try using evaluate
<cfset intRecordCount = evaluate ("#queryName#.recordcount")>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
