How do I set a variable equal to the recordcount of this query? Here's what
I've been trying....
<~~~~~~~~~~~~~CODE~~~~~~~~~~~~~~~~>
<cfset queryName = "MyQuery">
<cfquery name="#queryName#" datasource="#application.dns#" dbtype="ODBC"
username="#application.dns_username#" password="#application.dns_password#"
cachedwithin="#CreateTimeSpan(0,0,10,0)#">
SELECT *
FROM data
WHERE dataid = #dataid#
</cfquery>
<cfset queryCount = evaluate(queryName & ".recordcount")>
<cfoutput>#queryCount#</cfoutput>
<cfabort>
<~~~~~~~~~~~~~CODE~~~~~~~~~~~~~~~~>
This code returns the following error:
<~~~~~~~~~~~~~ERROR~~~~~~~~~~~~~~~~>
Error Diagnostic Information
An error occurred while evaluating the expression:
queryCount=evaluate(queryName & ".RecordCount")
Error near line 109, column 7.
An error has occurred while processing the expression:
21.RecordCount
Invalid parser construct found on line 1 at position 4. ColdFusion was
looking at the following text:
RecordCount
Invalid expression format. The usual cause is an error in the expression
structure.
<~~~~~~~~~~~~~ERROR~~~~~~~~~~~~~~~~>
Seems like I've done this a million times, but I'm not hitting on all
cylinders today. The name of the query is an integer if that makes any
difference. Can somebody point out the obvious for me?
Thanks,
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
