displaying top 100 results
Tracker Issue Enhancement Request: CFQuery Analyzer
Enhancement Request: CFQuery Analyzer
Tracker Issue Connection not reset after each CFQuery
Connection not reset after each CFQuery
Tracker Issue SQL comments inside CFQuery are not ignored
SQL comments inside CFQuery are not ignored
Tracker Comment Comment on Enhancement Request: CFQuery Analyzer by CFwatson U.
Comment on Enhancement Request: CFQuery Analyzer by CFwatson U.
Tracker Comment Comment on Enhancement Request: CFQuery Analyzer by CFwatson U.
Comment on Enhancement Request: CFQuery Analyzer by CFwatson U.
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.
Tracker Comment Comment on Connection not reset after each CFQuery by Nimit S.
Comment on Connection not reset after each CFQuery 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 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.
Tracker Comment Comment on Connection not reset after each CFQuery by Nimit S.
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.
Tracker Comment Comment on Connection not reset after each CFQuery by Nimit S.
Comment on Connection not reset after each CFQuery by Nimit S.
Tracker Issue String methods process single quotes differently when CFSet is used inside a CFQuery block
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.
Tracker Issue Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues
Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues
Tracker Comment Comment on Connection not reset after each CFQuery by Rupesh K.
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.
Tracker Comment Comment on SQL comments inside CFQuery are not ignored by Jay G.
Comment on SQL comments inside CFQuery are not ignored by Jay G.
Comment on SQL comments inside CFQuery are not ignored by CFwatson U.
Tracker Comment Comment on String methods process single quotes differently when CFSet is used inside a CFQuery block by External U.
Comment on String methods process single quotes differently when CFSet is used inside a CFQuery block by External U.
Tracker Comment 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 Aaron N.
Tracker Comment 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 Sanjeev K.
Tracker Comment Comment on Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues by External U.
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.
Tracker Comment 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.
Tracker Comment 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 External U.
Tracker Comment 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 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.
Tracker Issue CFQUERY turns Emojis into Question marks
CFQUERY turns Emojis into Question marks
Tracker Comment 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 External U.
Bug 81968:CFQUERY doesn't use the datasource passed, it uses the datasource of the final CFQUERY before the closing /CFQUERY tag
Tracker Issue Security Analyzer and dbtype="query" within cfquery
Security Analyzer and dbtype="query" within cfquery
Tracker Issue The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of 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")
Tracker Comment 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 External U.
Should you convert all your CFQUERY sql to stored procedures? A different perspective
Tracker Issue Bug 82779:cfquery
Bug 82779:cfquery
Comment on cfquery sandbox security issue after CF2016 update 4 by Chris D.
Comment on Variable cfquery> is undefined by Poonam J.
Comment on Variable cfquery> is undefined by Poonam J.
Comment on cfquery crashes when there are tsql comments by External U.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment Comment on Ehcache with CFQuery: not responsive and stops caching after Query Cache Size reached 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.
Tracker Comment Comment on Separate parameters from SQL in <cfquery> by Chris H.
Comment on Separate parameters from SQL in <cfquery> by Chris H.
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.
Tracker Comment Comment on Bug 77370:cfquery will use "this by External U.
Comment on Bug 77370:cfquery will use "this by External U.
Tracker Comment Comment on Bug 77370:cfquery will use "this by External U.
Comment on Bug 77370:cfquery will use "this by External U.
Tracker Comment Comment on Bug 77370:cfquery will use "this by External U.
Comment on Bug 77370:cfquery will use "this 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
Tracker Comment 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 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:
Portal Comment Comment on TSQL – Getting New Primary Key by David Byers
David Byers How about using <cfquery name="myQuery" result="myQuery_Result"> and then calling #myQuery_Result.generatedKey#?
Portal Comment Comment on Bulk Inserting Data by Spidey9000
Spidey9000
I think you’ve got your closing cfquery and cfloop tags reversed in your bulk load.
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.
Tracker Comment Comment on cfquery cachedafter by Nimit S.
Comment on cfquery cachedafter by Nimit S.
Comment on Variable cfquery> is undefined by Poonam J.
Comment on Variable cfquery> is undefined by Anit K.
Comment on cfquery crashes when there are tsql comments by External U.
Tracker Comment 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 Luis M.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment 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.
Tracker Comment Comment on cfquery/queryExecute - Add Return Type by External U.
Comment on cfquery/queryExecute - Add Return Type by External U.
Tracker Comment Comment on cfquery/queryExecute - Add Return Type by External U.
Comment on cfquery/queryExecute - Add Return Type by External U.
Tracker Comment Comment on CFQuery's recordCount is not reliable for SQL Server datasources by Nimit S.
Comment on CFQuery's recordCount is not reliable for SQL Server datasources by Nimit S.