Migrator - addRecord doesn't work right for sql server if you have a number in a text field #871
Description
In lines 240- 244
https://github.com/cfwheels/cfwheels/blob/master/wheels/migrator/Migration.cfc#L243
Migrator is checking if the value is a boolean or numeric but not taking into account field type.
So if you have a value of 1 in a text field it will not put ticks '1' around the value which is required for SQL server and maybe other engines. mysql doesn't seem to care so it works.
if(IsNumeric(arguments[local.key])) {
local.columnValues = ListAppend(local.columnValues,arguments[local.key]);
} else if(IsBoolean(arguments[local.key])) {
local.columnValues = ListAppend(local.columnValues,IIf(arguments[local.key],1,0));