Need to build a list of record counts....
What's wrong with this?
<cfoutput query="BUILDINGS">
<!--- RUN A SUB QUERY TO COUNT THE ROOMS --->
<cfquery name="roomCOUNTER" datasource="term">
SELECT *
FROM Q_D2
WHERE ACTPRYSID = #BUILDINGS.PRYSID#
</cfquery>
<CFSET COUNT_LIST=ValueList(roomCOUNTER.recordcount)>
</cfoutput>
<cfoutput>#roomCOUNTER.recordcount#</cfoutput> displays correctly if placed
inside the loop. But setting the list errors out:
The ValueList() function has an invalid parameter: roomCOUNTER.recordcount.
Parameter 1 of function ValueList which is now (roomCOUNTER.recordcount)
must be pointing to a valid query name.
Uhh...it *IS* a valid query name, otherwise #roomCOUNTER.recordcount#
wouldn't work...
So, how else would I go about it?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
