search : cfquery

select a category, or use search below
(searches all categories and all time range)

displaying top 100 results

Enhancement Request: CFQuery Analyzer
Connection not reset after each CFQuery
SQL comments inside CFQuery are not ignored
Comment on SQL comments inside CFQuery are not ignored by Kevin P.
Comment on SQL comments inside CFQuery are not ignored by External U.
Comment on SQL comments inside CFQuery are not ignored by Kevin P.
Comment on Connection not reset after each CFQuery by External U.
Comment on Connection not reset after each CFQuery by External U.
Comment on SQL comments inside CFQuery are not ignored by Nimit S.
Comment on Connection not reset after each CFQuery by External U.
Comment on Connection not reset after each CFQuery by External U.
Comment on Connection not reset after each CFQuery by External U.
Comment on Connection not reset after each CFQuery by External U.
Comment on Connection not reset after each CFQuery by Nimit S.
Comment on SQL comments inside CFQuery are not ignored by External U.
Comment on SQL comments inside CFQuery are not ignored by Aaron N.
Comment on Connection not reset after each CFQuery by Nimit S.
String methods process single quotes differently when CFSet is used inside a CFQuery block
Comment on Connection not reset after each CFQuery by External U.
Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues
Comment on Connection not reset after each CFQuery by Rupesh K.
Comment on SQL comments inside CFQuery are not ignored by CFwatson U.
Comment on Connection not reset after each CFQuery by External U.
Comment on SQL comments inside CFQuery are not ignored by Jay G.
Comment on SQL comments inside CFQuery are not ignored by CFwatson U.
Comment on String methods process single quotes differently when CFSet is used inside a CFQuery block by External U.
Comment on Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues by Aaron N.
Comment on Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues by Sanjeev K.
Comment on Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues by External U.
Comment on cfquery crashes when there are tsql comments by External U.
Comment on cfquery crashes when there are tsql comments by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery by External U.
Comment on The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery by Suchika S.
Comment on Separate parameters from SQL in <cfquery> by Rupesh K.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Separate parameters from SQL in <cfquery> by Vamseekrishna N.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Separate parameters from SQL in <cfquery> by External U.
CFQUERY turns Emojis into Question marks
Comment on The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery by External U.
Bug 81968:CFQUERY doesn't use the datasource passed, it uses the datasource of the final CFQUERY before the closing /CFQUERY tag
Security Analyzer and dbtype="query" within cfquery
The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery
Bug 82164:(Watson Migration Closure)[ANeff] ER for: cfquery/cfcache integration (<cfquery cacheID="PassedThruAsID" cachedWithin="PassedThruAsTimespan")
Comment on The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery by External U.
Tracker Issue Bug 82779:cfquery
Bug 82779:cfquery
Comment on cfquery sandbox security issue after CF2016 update 4 by Chris D.
Comment on cfquery crashes when there are tsql comments by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on Ehcache with CFQuery: not responsive and stops caching after Query Cache Size reached by External U.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Separate parameters from SQL in <cfquery> by External U.
Comment on Trim() adds doubles apostrophes in cfquery by External U.
Comment on Trim() adds doubles apostrophes in cfquery by Himavanth R.
Comment on Trim() adds doubles apostrophes in cfquery by External U.
Comment on cfquery datasource attribute leak / scoping issue by External U.
Comment on cfquery datasource attribute leak / scoping issue by External U.
cfquery query of queries count(*) returns nothing when there are 0 rows
Bug 83898:(Watson Migration Closure)This is a suggestion for CFQUERY
Unable to insert unicode character ' ñ ' in SQL Server 2014 using cfquery
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on Bug 79382:When you have a cfquery that within its body calls any cffunction that itself runs a cfquery, the containing cfquery will use the function’s query’s datasource and ignore the one passed to it as an at by External U.
Portal Topic Bulk Inserting Data
Dave Ferguson Bulk Inserting Data One of the operations that we do often is insert multiple rows into a database.  Your inclination is probably to just loop over a cfquery and do the inserts.  While this will work it creates some excess overhead.   Your code may look something like this:
David Byers How about using <cfquery name="myQuery" result="myQuery_Result"> and then calling #myQuery_Result.generatedKey#?
Bug 74799:No access to cfquery's Result struct when using new query()
Comment on cfquery sandbox security issue after CF2016 update 4 by S P.
Comment on cfquery crashes when there are tsql comments by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by Luis M.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on cfquery/queryExecute - Add Return Type by External U.
Comment on cfquery/queryExecute - Add Return Type by External U.
Comment on CFQuery's recordCount is not reliable for SQL Server datasources by Nimit S.
Comment on cfquery result no longer returns IDENTITYCOL with MSSQL 2012 by External U.
2609782 CF-3775860 Adobe D. Tested in CF11 Update 3 and following is the findings: Select query:- ORMExecuteQuery.cfm: CFQuery.cfm: select id, comment from Perf The table Perf has 1000 records and here we are doing select query. Over 100 Samples, average request completion time comes out as