Cached Query
I have a situation that shows up every once in awhile and I'm not sure why it's occuring.
I have a query that is cached and just below the query I display information from that query. Sometimes coldfusion will say the variable from the query does not exist. I don't understand why this happens since the query is directly above the output and I'm asking for the number of records so I should atleast get a number.
Example:
<cfquery name="NumLogins" datasource="#application.datasource#" dbtype="ODBC" cachedwithin="#application.admin_query_cache_time#">
select login_id from logins where company_id = #company_id# and company_login_id = #company_login_id#
</cfquery>
Number of Logins: <cfoutput>#NumLogins.recordcount#</cfoutput>
Any help would be greatly appreciated.
Thanks!
Torri
