displaying top 100 results
Tracker Issue query without cfqueryparam strange behaviour
query without cfqueryparam strange behaviour
Issue using "DateConvert("local2Utc",now())" with cfqueryparam
Tracker Issue support uniqueidentifier (guid) in cfqueryparam sqltype
support uniqueidentifier (guid) in cfqueryparam sqltype
Tracker Issue Bug 78547:(Watson Migration Closure)I love cfqueryparam
Bug 78547:(Watson Migration Closure)I love cfqueryparam
Tracker Issue [ANeff] Doc Bug for: cfqueryparam incorrect MSSQL types
[ANeff] Doc Bug for: cfqueryparam incorrect MSSQL types
Tracker Comment Comment on Issue using "DateConvert("local2Utc",now())" with cfqueryparam by External U.
Comment on Issue using "DateConvert("local2Utc",now())" with cfqueryparam by External U.
Tracker Comment Comment on Issue using "DateConvert("local2Utc",now())" with cfqueryparam by External U.
Comment on Issue using "DateConvert("local2Utc",now())" with cfqueryparam by External U.
Comment on query without cfqueryparam strange behaviour by CFwatson U.
Comment on query without cfqueryparam strange behaviour by CFwatson U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
[ANeff] Doc Bug for: CF10's new CF_SQL_ types undocumented in cfqueryparam doc
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on support uniqueidentifier (guid) in cfqueryparam sqltype by Nimit S.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Tracker Issue cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors
cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors
Tracker Comment Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by External U.
Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by External U.
Tracker Comment Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by Himavanth R.
Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by Himavanth R.
Tracker Comment Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by Frank J.
Comment on cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors by Frank J.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Comment on Bug 78547:(Watson Migration Closure)I love cfqueryparam by External U.
Tracker Comment Comment on [ANeff] Doc Bug for: CF10's new CF_SQL_ types undocumented in cfqueryparam doc by Nimit S.
Comment on [ANeff] Doc Bug for: CF10's new CF_SQL_ types undocumented in cfqueryparam doc by Nimit S.
Tracker Comment Comment on [ANeff] Doc Bug for: CF10's new CF_SQL_ types undocumented in cfqueryparam doc by Saurav G.
Comment on [ANeff] Doc Bug for: CF10's new CF_SQL_ types undocumented in cfqueryparam doc by Saurav G.
Tracker Issue Bug 85843:When you are manually doing a cfquery with the type of HQL, the cfqueryparam makes your hql case sensitve
Bug 85843:When you are manually doing a cfquery with the type of HQL, the cfqueryparam makes your hql case sensitve
Comment on The Hidden Power Of CFQUERYPARAM! by Bernhard Döbler
Comment on Do not evaluate value if null=tue on CFQUERYPARAM by External U.
Comment on CFQUERYPARAM performance issue in Coldfusion 10 by External U.
Portal Topic The Hidden Power Of CFQUERYPARAM!
The Hidden Power Of CFQUERYPARAM!
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Tracker Comment Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Alexandre P.
Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Alexandre P.
2611837 CF-3585643 Himavanth R. Not a good use case.
It works fine for cfqueryparam.
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by David Byers
Comment on The Hidden Power Of CFQUERYPARAM! by David Byers
The attribute cfsqltype="cf_sql_timestamp" of cfqueryparam and cfprocparam enforces a decimal point in the number of seconds, irrespective of the date format
Tracker Issue Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO"
Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO"
Portal Topic Bulk Inserting Data
array="#users#" index="u"> insert into mytable (firstname, lastname, email) values ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#u.firstname#">, <cfqueryparam cfsqltype="cf_sql_varchar" value="#u.lastname#">, <cfqueryparam cfsqltype="cf_sql_varchar" value
Tracker Comment Comment on Create Admin Option to Require Use of <cfqueryparam> Inside <cfquery> tags by External U.
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by External U.
Tracker Comment Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Tracker Comment Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Tracker Comment Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
Portal Comment Comment on Query by week by Tom Chiverton
Tom Chiverton You don't say what your database is, but something like
WHERE shipdate < <cfqueryparam value="#dateAdd(-1,'w',now())#" cfsqltype="datestamp"/> AND shipdate > <cfqueryparam value="#dateAdd(-2,'w',now())#" cfsqltype="datestamp"/>
Tracker Comment Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2613212 CF-3338974 External U. I applied the updater 3 that came out today. It fixes the display function issues that I found.
It DOES NOT fix the <cfqueryparam issue that I submitted as "CF10DateErrors-2.cfm".
Either re-open this ticket or link it to one that is for <cfqueryparam not working
Tracker Issue Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query
Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query
Tracker Issue Cfqueryparam / queryExecute / Query CFC - Accept arrays
Cfqueryparam / queryExecute / Query CFC - Accept arrays
Bug 87054:(Watson Migration Closure)CFQUERYPARAM is not allowing users to define scale="0" even though scale="0" is the default
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Comment on CFQUERYPARAM performance issue in Coldfusion 10 by Nimit S.
Tracker Comment Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
Tracker Comment Comment on Create Admin Option to Require Use of <cfqueryparam> Inside <cfquery> tags by External U.
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by External U.
Tracker Comment Comment on Support plain-named query param types by Rupesh K.
2611501 CF-3616682 Rupesh K. We need to have a consistency between cfqueryparam and cfprocparam as both have cfsqltype attribute. And type is already an attribute on cfprocparam tag. That rules out 'type'
Tracker Comment Comment on Frequent key collisions on cached queries resulting in wrong (cached) result-set returned by External U.
2612923 CF-3369530 External U. until it's fixed our ability to effectively use caching on ColdFusion 10 with cfqueryparam is hampered.
Comment on Bug 87054:(Watson Migration Closure)CFQUERYPARAM is not allowing users to define scale="0" even though scale="0" is the default by Aaron N.
Tracker Comment Comment on Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query by External U.
Comment on Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query by External U.
4267605 CF-4202219 Aaron N. Related thread: https://forums.adobeprerelease.com/coldfusionpr/discussion/274/cfqueryparam-null-100-cpu
Tracker Comment Comment on [ANeff] Bug for: NULL exceptions by Aaron N.
4288021 CF-4202301 Aaron N. To clarify, that was the only time these errors were logged. But, also, that was the only time I was testing cfqueryparam's null attribute. So.. there's an issue.. I just gotta spend time to narrow it down.
Thanks!,
-Aaron
2704911 CF-4198194 Aaron N. Hi Nimit,
Thank you very much!
I'm just adding the following word into this ticket, to make the ticket easier to find: cfqueryparam
Thanks!,
-Aaron
Tracker Issue Do not evaluate value if null=tue on CFQUERYPARAM
Do not evaluate value if null=tue on CFQUERYPARAM
Tracker Issue CFQUERYPARAM performance issue in Coldfusion 10
CFQUERYPARAM performance issue in Coldfusion 10
Derby datasource doesn't work with CFQUERYPARAM null values
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by External U.
Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by External U.
Tracker Comment Comment on [ANeff] Bug for: NULL exceptions by Aaron N.
4288021 CF-4202301 Aaron N. Hi Vamsee,
I've confirmed that cfqueryparam's null attribute had nothing to do w/ this issue.
audit.log reveals that I did not even create the DSN I'd used for cfqueryparam testing until 10 minutes _after_ these null messages were logged.
Additionally, IIS's log files
of cfqueryparam info, except 'type' instead of 'cfsqltype'
myColumn2 = {value=true, type="bit"}//struct of cfqueryparam info, except 'type' instead of 'cfsqltype'
};
cfupdate(tableName="myTable", fields=myFields);
Thoughts?
Thanks!,
-Aaron
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by Aaron Neff
Comment on The Hidden Power Of CFQUERYPARAM! by Aaron Neff
Comment on The Hidden Power Of CFQUERYPARAM! by Charlie Arehart
Comment on The Hidden Power Of CFQUERYPARAM! by Charlie Arehart
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by jaschu
Comment on The Hidden Power Of CFQUERYPARAM! by jaschu
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Vamseekrishna N.
Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Vamseekrishna N.
Comment on Security Analyzer - case sensitivity for <cfqueryparam> by CFwatson U.
Tracker Comment Comment on Derby datasource doesn't work with CFQUERYPARAM null values by Himavanth R.
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by Himavanth R.
Tracker Comment Comment on Create Admin Option to Require Use of <cfqueryparam> Inside <cfquery> tags by Rupesh K.
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by Rupesh K.
Tracker Comment Comment on Frequent key collisions on cached queries resulting in wrong (cached) result-set returned by External U.
2612923 CF-3369530 External U. One additional workaround is to roll your own unique ID and use the new "cacheID" attribute of CFQuery. I did this by making a struct of key/value pairs for the various SQL parameters, serializing it to JSON, then hashing it. Although I think adding the cfqueryparam
Tracker Comment Comment on Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query by External U.
Comment on Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query by External U.
Tracker Issue Dramatic change to CF9's implementation of CFQuery causes major backwards compatibility issues
capability for certain dynamic programming techniques in ColdFusion.
The code below works in ColdFusion 9 and now errors out with whatever cfqueryparam type the column is ( note no cfqueryparams are even used )
Invalid data { anyNonSimpleContent = true } for CFSQLTYPE CF
Tracker Comment Comment on [ANeff] Doc Bug for: CFFiddle's restricted tags and functions undocumented by Aaron N.
4454464 CF-4202844 Aaron N. Hi Adobe,
Note: During PR, Adobe listed these CFFiddle restricted tags/functions:
-----------
ColdFusion Tags
* cfexecute,
* cfregistry,
* cfquery,
* cfdbinfo,
* cfprocparam,
* cfqueryparam,
* cfupdate,
* cfinsert,
* cfprocresult,
* cfstoredproc,
* cfobjectcache
Tracker Issue Security Analyzer - case sensitivity for <cfqueryparam>
Security Analyzer - case sensitivity for <cfqueryparam>
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by Eric Cobb
Comment on The Hidden Power Of CFQUERYPARAM! by Eric Cobb
Tracker Issue [ANeff] ER for: isValid() datetimeobject
3557163 CF-4199894 Language : Functions Aaron Neff [ANeff] ER for: isValid() datetimeobject This ER is for: isValid("datetimeobject")
With few exceptions (ex: cfqueryparam's cfsqltype and CGI variables), CF does not use underscores in attribute names, parameter values, variable names, etc
Tracker Comment Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
2613212 CF-3338974 External U. This effects virtually ALL functionality dealing with time that I tested. Even when I passed "DateConvert('local2Utc',now())" directly to cfqueryparam, the original date was stored in the DB instead of the UTC value.
My suspicion is that this could all be because
Tracker Comment Comment on Bug 72824:(Watson Migration Closure)handling timezones (tz) in cf is complicated and often misunderstood by External U.
2603180 CF-3035908 External U. This is now a required feature (and should be "un-deferred") due to:
1) CF10 changed behavior of dateConvert(). It now only changes the string representation of a date/time object but no longer changes the underlying numeric value. Thus, cfqueryparam sends values
Tracker Comment Comment on ColdFusion errors when inserting, updating or selecting Oracle 12c Varchar2 columns that are over 4000 characters by Matthew H.
3194404 CF-4198861 Matthew H. This is marked as third party. That is not correct unles the 3rd party is the driver. The error is either in CF or the driver, not Oracle. If you run a merge statement with a clob field using , you will get this error. If you look at the params listed, cfqueryparam
Tracker Comment Comment on [ANeff] Bug for: NULL exceptions by Aaron N.
support w/ cfqueryparam's null attribute at the time these errors were logged.
I'll see if I can remember what I was doing and follow-up.
It's really too bad that Tracker's email notification system's been broken! I wish I'd have seen Immanuel's message that same day. Can you please ask the Tracker team
that variable for just about anything (including cfqueryparam), the value you get back is off by the amount of the offset (i.e. back to the value you passed in).
Steps to Reproduce:
1) Assign the result of "DateConvert("local2Utc",now())" to a variable.
2) Use it in any number of functions or tags that deal
<cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0
Tracker Issue Invalid / Strange casting on cf_sql_integer
to Reproduce:
create table ##tmp (col1 int)
insert into ##tmp (col1) values()
select * from ##tmp
drop table ##tmp
Actual Result:
-657436 is inserted in the table even though we have validated that the value passed to cfqueryparam is neither numeric or an integer.
Expected Result
Create Admin Option to Require Use of <cfqueryparam> Inside tags
Tracker Issue Trim() adds doubles apostrophes in cfquery
#expected# - #badresult#
Actual Result:
The variable "badresult" contains duplicated apostrophes, but the "expected" variable is normal.
Expected Result:
I would expect Trim() to always work as documented. Apostrophes should only duplicate if used without a cfqueryparam and without Preserve
Tracker Issue cfProcParam's MaxLength does absolutely nothing
="in" and cfsqltype="CF_SQL_VARCHAR". Set this maxlength to a value above 0 and then enter for the value a string greater than that length.
Actual Result: Nothing happens
Expected Result: An error similar to cfqueryparam's maxlength
Any Workarounds: None to my knowledge
----------------------------- Additional
Bug 80196:An empty list passed to <cfqueryparam cfsqlype="cf_sql_integer" value="#list#" list="true"/> causes an exception to be thrown (because "" is not a valid integer)
Tracker Issue Implement Fuzzy Code Hints
2682678 CFB-3764769 Editor Features CFJSGeek Implement Fuzzy Code Hints Currently when the list of available attributes such as cfsqltype on a cfqueryparam tag list, you have to type from the beginning on. For example I must type "cf_sql_v" to get "cf_sql_varchar".
I suggest implement fuzzy list
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Ashudeep S.
Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Ashudeep S.
treated & parsed ISO8601 extended strings as valid date values. This would enable CFQUERYPARAM to function without having to first parse/convert. (NOTE: ISO8601 "Basic" format YYYYMMDD may be wrongly interpreted as an integer or a epoch/Unix timestamp.)
A feature like this would be better as a
2609104 CF-3929913 External U. Hi Himavanth,
Regarding my previous comment about storing q.dateColumn into db, my looked like this:
<cfqueryparam cfsqltype="#columnTypeFromCFDBINFO#" value="#trim(myValue)#"..
I was dynamically populating both the cfsqltype AND the trimmed value. In CF11, if my
Tracker Comment Comment on Java bug in CF by External U.
't involved database. I called a module that returned these variables and didn't encounter any problems regarding the unscoped "Agentfullname" variable name.
I highly recommend using CFQueryParam around every value (especially FORM & URL) used in a database query otherwise it could easily be susceptible
Comment on Bug 80196:An empty list passed to <cfqueryparam cfsqlype="cf_sql_integer" value="#list#" list="true"/> causes an exception to be thrown (because "" is not a valid integer) by External U.
, INSERT INTO, UPDATE and that URL variable is found within a CFQUERY tag without using CFQUERYPARAM, that is a pretty obvious security threat. It would be extremely nice if we could setup an event handler in the Application.cfc file to handle these circumstances.
The OnSecurityBreach should have some
Tracker Issue Enhancement Request: CFQuery Analyzer
in cfquery statements instead of SELECT TOP 100 or other database dependent row-limiting operations.
#3 - It is already in the "Security Analyzer" but if the programmer is not using cfqueryparam and should be, show a warning here as well.
#4 - If a server is defined in Blizzard, perhaps Bilzzard could