tracker issue : CF-3037466

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

Bug 75365:(Watson Migration Closure)Bug for: Type validation is not performed, when array notation is used to set query cell values

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/LowImpact

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 02/07/2009

Components: Database, CFQuery

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Most users will encounter

Locale/System: English / Platforms All

Vote Count: 1

Problem:

Bug for: Type validation is not performed, when array notation is used to set query cell values. querySetCell does perform type validation.

Related thread: https://prerelease.adobe.com/r/?4eaf0f675f184e2f87afc83930de3b9e
Method:

Example:

<cfscript>
  myQuery = queryNew("myQueryColumn", "integer");
  queryAddRow(myQuery, 2);
  querySetCell(myQuery, "myQueryColumn", 1, 1);
  myQuery.myQueryColumn[2] = "NO TYPE VALIDATION HAPPENING HERE";
  dump(var=getMetaData(myQuery));
  dump(var=myQuery);
</cfscript>
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3037466

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email: 3D1D17B03C844EBF992001AC
External Test Config: 02/07/2009

Attachments:

Comments:

This bug has been voted..
Vote by External U.
24043 | November 10, 2011 07:16:00 PM GMT
I hope this can be considered for CF12. When using array notation to set a query cell's value, and if the value being set is a simple value, then type validation should apply. Since there isn't an "any" data type, and since existing code can set complex values into query cells using array notation, then type validation shouldn't apply if the value being set is a complex value. Thanks!, -Aaron
Comment by External U.
24042 | September 12, 2015 01:52:21 AM GMT