search : cfqueryparam

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

displaying top 100 results

query without cfqueryparam strange behaviour
Issue using "DateConvert("local2Utc",now())" with cfqueryparam
support uniqueidentifier (guid) in cfqueryparam sqltype
Bug 78547:(Watson Migration Closure)I love cfqueryparam
[ANeff] Doc Bug for: cfqueryparam incorrect MSSQL types
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.
cfqueryparam cf_sql_timestamp represenation in MS SQL Server results in rounding errors
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 Himavanth R.
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.
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 Saurav G.
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.
The Hidden Power Of CFQUERYPARAM!
Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
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.
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
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
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by External U.
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.
Comment on Bug 78911:(Watson Migration Closure)Add support to autodetect nulls passed to CFQUERYPARAM when NULL="AUTO" by External U.
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"/>
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
Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query
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
Comment on The Hidden Power Of CFQUERYPARAM! by James Mohler
Comment on CFQUERYPARAM performance issue in Coldfusion 10 by Nimit S.
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by External U.
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by External U.
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'
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.
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
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
Do not evaluate value if null=tue on CFQUERYPARAM
CFQUERYPARAM performance issue in Coldfusion 10
Derby datasource doesn't work with CFQUERYPARAM null values
Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by External U.
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
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
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.
Comment on Derby datasource doesn't work with CFQUERYPARAM null values by Himavanth R.
Comment on Create Admin Option to Require Use of <cfqueryparam> Inside tags by Rupesh K.
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
Comment on Bug 79024:(Watson Migration Closure)I use: where FIELD in ( <cfqueryparam type="varchar" value="#valueList( query by External U.
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
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
Security Analyzer - case sensitivity for <cfqueryparam>
Comment on The Hidden Power Of CFQUERYPARAM! by Eric Cobb
3557163 CF-4199894 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. Related Tickets
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
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
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
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
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
#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
="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)
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
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
'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
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
in case 1, 2 Query result for "RAB160" is returned in case 3. Expected Result: Query result for "RGB100" is returned in case 1 Query result for "RAB160" is returned in case 2, 3. Any Workarounds: - Don't cache the query - Don't use cfqueryparam - Add (SQL) comment containing all queryparam values
return a special object (like struct/array) that can be used. However, to be more CF like it should act more like an empty string. If you try to append this object to a string it simply appends an empty string. If you call Len() on the object it returns 0.Tags like cfqueryparam though if the Null object