If I've got a query using a CFQUERYPARAM in the WHERE clause and then attempt to cache that query, will the query remain in CF's cache when called with different values for the queryparam?
For example, the table 'mytable' is a very small table with just 5 rows: <cfquery datasource="#dsn#" name="myquery"> SELECT something, somethingsomething FROM mytable WHERE mytableid = <cfqueryparam cfsqltype="cf_sql_integer" value="#id#"> </cfquery> And if I call that query alternately with different identifiers, 1, 2, 3, etc., will the query remain cached? In CF's debugging output I'm seeing 'Time=Cached Query', but I don't understand how CF could cache the query unless it caches the query results for each possible queryparam value. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
