Status/Resolution/Reason: Closed/Deferred/NotEnoughTime
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 03/25/2012
Components: Language, Functions
Versions: 10.0
Failure Type: Enhancement Request
Found In Build/Fixed In Build: Public Beta /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Currently this fails: q = queryNew("c1,c2,c3", "varchar,,varchar", [{c1=1,c2={complex=true},c3=3}])
Error: "The list of column names should have the same size as the list of column types.
Size of column names 3 is different from size of column types 2"
Since queryNew() permits untyped-columns, a new column type "any" should be allowed in queryNew()’s ColumnTypeList.
Ex: q = queryNew("c1,c2,c3", "varchar,any,varchar", [{c1=1,c2={complex=true},c3=3}])
Additionally, a querySetColumnType(query, column_name, data_type) would allow a column's type to be changed. This would permit us to still set complex values into cells of cfquery-returned queries, b/c we could change the type of the column before writing the complex value.
Ex: querySetColumnType(q, "myCol", "any");//change myCol's column type to "any" (to permit complex data types)
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3148703
External Customer Info:
External Company:
External Customer Name: itisdesign
External Customer Email:Attachments:
Comments: