Title:
Issues with setting query values through array notation because of type validation
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): / ext-user (Himavanth Rachamsetty)
Created: 07/02/2014
Versions: 10.0
Failure Type: Unspecified
Found In Build/Fixed In Build: cf10 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Mac 10 All,Win XP All
Vote Count: 0
queryTest = queryNew(
"Name,Amount,DateCreated"
, "varchar,integer,date"
);
data = [
["Bob", 42, "2014-01-01 12:00:00"]
, ["Fred", 32, "2014-02-01 12:00:00"]
, ["Henry", 21, "2014-03-01 12:00:00"]
];
for( rowData in data ){
// add row
row = queryAddRow(queryTest);
querySetCell(queryTest, "Name", rowData[1], row);
querySetCell(queryTest, "Amount", rowData[2], row);
querySetCell(queryTest, "DateCreated", rowData[3], row);
}
I then trying changing the values:
<!---// problem w/date data typing //--->
<cfset queryTest.DateCreated[1] = "Jun 1, 2014" />
<cfset queryTest.DateCreated[2] = "xxx" />
<!---// problem w/date data typing //--->
<cfset queryTest.Amount[1] = "1,5" />
Difference in output with cf9 vs cf10 is shown in the attached jpg file.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3784311
External Customer Info:
External Company:
External Customer Name:
External Customer Email:Attachments:
Comments: