Ask a Question related to Coldfusion Server Administration, Design and Development.
-
Denim Group #1
Coldfusion 5.0 cachedwithin & cfqueryparam
Running Coldfusion Enterprise Server 5.0, our staging environment is allowing
the following type query:
<cfquery name="rsCategories" datasource="Northwind"
cachedwithin=#CreateTimeSpan(1,0,0,0)#>
SELECT CategoryID, CategoryName FROM Categories
WHERE CategoryID = <CFQUERYPARAM value='#myValue#'>
</cfquery>
In production, the above type query gives an error, complaining of the
CFQUERYPARAM being used with the cachedwithin attribute. According to the
documentation, it should give an error, so how come it does not give an error
in staging? If we make a change to the query in staging, such as a syntax
error, it does reflect the changes in staging, which means it's not caching the
page from an earlier version when the CFQUERYPARAM was not included.
Any help would be greatly appreciated. Thank you!
Denim Group Guest
-
cachedwithin java error after upgrade to 7.02
We've just upgraded a server from 7 to 7.02, and have identified that queries now throw an error when cachedwithin is included in the query tag. ... -
Problem using cfqueryparam
CF throw me an error if I use <cfqueryparam cfsqltype="cf_sql_longvarchar"... on MS Access Memo field. My data in the Memo field is around 1000+... -
cfqueryparam
Hi, I am trying to take values passed through a form and do a search based on that, but I am getting an error Error Executing Database Query.... -
CFQUERYPARAM Error
Hello, I am using MX7 and am having problems with cfqueryparam. I am new to a project and the old code does not use them and everything I have... -
sql in operator with cfqueryPARAM
here is my query select distinct option_type, description, id from option_types where id NOT IN(<cfqueryPARAM value = "#mikeslist#" CFSQLType =...



Reply With Quote

