Question
Cfquery - Use cfqueryparam and cachewithin on same query
Question:
How can we use cachedwithin and cfqueryparam together in the same query? When I run the following code, It states that the two cannot be used together:
<cfquery name="get_something" datasource="#application.datasource#" cachedwithin="#CreateTimeSpan(1,0,0,0)#">
SELECT * from tablename
WHERE id = (<cfqueryparam value=#someid# cfsqltype="cf_sql_bigint">)
</cfquery>
I would like to be able to cache the query and also validate the value being passed to it.
Any ideas on how to pull it off?
How can we use cachedwithin and cfqueryparam together in the same query? When I run the following code, It states that the two cannot be used together:
<cfquery name="get_something" datasource="#application.datasource#" cachedwithin="#CreateTimeSpan(1,0,0,0)#">
SELECT * from tablename
WHERE id = (<cfqueryparam value=#someid# cfsqltype="cf_sql_bigint">)
</cfquery>
I would like to be able to cache the query and also validate the value being passed to it.
Any ideas on how to pull it off?
AdChoices