displaying top 100 results
Tracker Issue Invalid / Strange casting on cf_sql_integer
Invalid / Strange casting on cf_sql_integer
Comment on Invalid / Strange casting on cf_sql_integer by Nimit S.
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Alexandre P.
Comment on cf_sql_integer" list="true" value=""> is coercing to 0 by Alexandre P.
Comment on Invalid / Strange casting on cf_sql_integer by External U.
Comment on Invalid / Strange casting on cf_sql_integer by External U.
Comment on Invalid / Strange casting on cf_sql_integer by External U.
New("foo", "integer", [["bar2"]]));
writeDump(q2);
Actual result: coldfusion.runtime.StructOrdered cannot be cast to coldfusion.runtime.Struct
Expected results:
Invalid data bar1 for CFSQLTYPE CF_SQL_INTEGER
Invalid data bar2 for CFSQLTYPE CF_SQL_INTEGER
Invalid data bar3 for CFSQLTYPE CF_SQL_INTEGER
Related
Portal Comment Comment on The Hidden Power Of CFQUERYPARAM! by Aaron Neff
Aaron Neff Hi Adobe,
If you see my comment here, can you please document the fact that "cf_sql_" isn't needed (ex: cfsqltype="cf_sql_integer" can be shortened to cfsqltype="integer")? And can you please document which version removed that requirement? Was it CF11?
Thanks!,
-Aaron
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Vamseekrishna N.
Comment on cf_sql_integer" list="true" value=""> is coercing to 0 by Vamseekrishna N.
/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 The error occurred on line 24.
(param 1) = [type='IN', class='java.lang.String', value='55372666;', sqltype='CF_SQL_CHAR'] , (param 2) = [type='IN', class='java.lang.Integer', value='1', sqltype='CF_SQL_INTEGER'] , (param
Tracker Issue Named param replacement
AND artID < :param2",
{ param1: { value: 1, cfsqltype: "cf_sql_integer" },
param2: { value: 10, cfsqltype: "cf_sql_integer" }
},
{ datasource: "cfartgallery" }
);
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3943345
Bug 80196:An empty list passed to cf_sql_integer" value="#list#" list="true"/> causes an exception to be thrown (because "" is not a valid integer)
Tracker Issue [ANeff] Bug for: queryNew() not respecting column type
: exception "Invalid data bar for CFSQLTYPE CF_SQL_INTEGER"
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4117243
External Customer Info:
External Company:
External Customer Name: Aaron Neff
External Customer Email:
Tracker Issue Bad replacement of single quotes in already escaped values when using named parameters
. This does not happen if you're not using any named parameters
Steps to Reproduce:
Run the following query:
myQuery = New Query( sql: " SELECT 'It''s Time!' WHERE 1 = :Check" );
myQuery.addParam( name = "Check", cfsqltype = "cf_sql_integer", value = "1" );
result = myQuery.Execute();
Actual Result
Tracker Issue Support plain-named query param types
2611501 CF-3616682 Database : CFQuery Adam Cameron Support plain-named query param types See: http://cfmlblog.adamcameron.me/2013/08/minor-common-sense-tweak-to-cfml-from.html
Railo supports more obvious type names for tags, eg: "integer" rather than "CF_SQL_INTEGER". CF could join the party
Portal Topic ColdFusion performance issues and optimization
Fusion performance issues and optimization appeared first on ColdFusion. Blog,ColdFusion,Troubleshooting,100%,cf_sql_integer,cpu,cpu 100%,cpu_usage,heap_size,performance,troubleshooting
Example code from docs, which uses new script-based version of cfqueryparam:
q = new query();
q.setDatasource("cfartgallery");
q.setSQL("select * from art where artid = :artid and artistid = ?
and description like 'vams?%' and largeimage like '%:jpg");
q.addParam(name="artid",value="56",CFSQLType='CF_SQL_INTEGER
Tracker Issue addParam is not chainable
Qry = new Query(
datasource="DealerPeak",
sql="SELECT TOP(1) [Year], Car_Make, Car_Model FROM Vehicle WHERE Active = :Active AND Car_StatusID = :Car_StatusID ORDER BY CarIdentity DESC"
)
.addParam( name="Active", value="1", cfsqltype="cf_sql_integer" )
.addParam( name="Car_StatusID", value
Execute() QoQ param. Example:
{cfsqltype="cf_sql_integer", value=q1.valueList("id",","), list=true}
that's shorter than (where getting as array, then converting to list, is unnecessary):
{cfsqltype="cf_sql_integer", value=q1.valueArray("id").toList(), list=true}
However.. it'd be even nicer if delimiter
Tracker Issue Bin the generic CFScript approach and start again
(procedure="uspGetColours", datasource="scratch_mssql",result="script.result", fetchclientinfo=true, returncode=true) {
cfprocparam(value=URL.low, cfsqltype="CF_SQL_INTEGER");
cfprocparam(value=URL.high, cfsqltype="CF_SQL_INTEGER");
cfprocparam(type="out", variable="script.inclusiveCount", cfsqltype="CF_SQL_INTEGER
";
QueryExecute( qry , { id={ cfsqltype="cf_sql_integer", value="1" }} ,{datasource:'core'});
{code}
Note this is VERY similar to a closed/fixed bug [https://tracker.adobe.com/#/view/CF-4000264] where someone has the same issue but just with a question mark in the query
Actual Result:
Error while
).
Steps to Reproduce:
Consider this code:
Actual Result:
id
1 1
2 hello
3 3
{"COLUMNS":["ID"],"DATA":[[1],["hello"],[3]]}
followed by ColdFusion exception on line 8:
Invalid data hello for CFSQLTYPE CF_SQL_INTEGER.
Expected Result:
Using QueryNew should also throw an exception when
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by External U.
Comment on cf_sql_integer" list="true" value=""> is coercing to 0 by External U.
Tracker Comment Comment on <cfqueryparam cfsqltype="cf_sql_integer" list="true" value=""> is coercing to 0 by Ashudeep S.
Comment on cf_sql_integer" list="true" value=""> is coercing to 0 by Ashudeep S.
Comment on Bug 80196:An empty list passed to cf_sql_integer" value="#list#" list="true"/> causes an exception to be thrown (because "" is not a valid integer) by External U.
Tracker Issue Bug while using queryExecute
have a dao cfc which contains a function to insert the record
public numeric function create(numeric column1Value=0, string reviewDateFrom="") {
var loc= {};
loc.parameters = {
column1Value={value="#arguments.column1Value#", cfsqltype="cf_sql_integer", null="#arguments.column1Value EQ 0
Tracker Issue Bug 83517:(Watson Migration Closure)in the new cf9 cfscript query cfcyou must have a space after named parameters
space.positional params - "?" - work fine with no trailing space.
Method:
myQry = new query();myQry.setSql('select idfrom tablewhere id = :idand deleted = 0');myQry.addParam( name="id", value=0, cfsqltype='cf_sql_integer' );myQry.execute();If my :id is followed by a line break, it throws an error
Tracker Issue wierd query performance issue
Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 40483
i played around with the TOP N. ONLY TOP 20 takes long. TOP 19,21,25,50 whatever all take milliseconds
i played around with column list.
if i exclude the dataID column, it's instant.
if i alias dataID as something, it's instant.
if i
Tracker Comment Comment on query from cfoutput by External U.
HazUserInfo.ID#
select * from hazusersys
WHERE HazUserSys.ID =
recordcount: #getHazUserSys.RecordCount#
The error I am getting is: Invalid date ' ' for CFSQLTYPE CF_SQL_INTEGER. The spcific sequence of files
user where userid =
cf:queryparam(value="#user.getId()#",cfsqltype="cf_sql_integer");
}
Method:
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3037535
External Customer Info:
External Company:
External Customer Name: Jared C Rypka
Tracker Issue Bug 80519:the cfapplication tag is throwing an error in cf9 when I try to put in the datasource attribute
,SECUREJSON,SECUREJSONPREFIX,SERVERSIDEFORMVALIDATION,SESSIONMANAGEMENT,SESSIO NTIMEOUT,SETCLIENTCOOKIES,SETDOMAINCOOKIES.
[vmannebo 11/19/09]
Error Executing Database Query.
Datasource not found.
The error occurred in C:\work\depot\ColdFusion\cf_main\cfusion\wwwroot\bugs\81519\SP\sp.cfm: line 22
20 : DBVarName ="@data_type"
21 : value = "#count#"
22 : CFSQLType = "CF_SQL_Integer