when deploying boolean properties the database does not default the value

Description

when deploying boolean properties the database does get defaulted

e.g
<cfproperty ftSeq="2" ftFieldset="General" name="bBreaking" type="boolean" hint="If the main teaser is breaking news then show the appropriate heading" ftLabel="Breaking News?" ftType="boolean" default=0/>

does not default row values as false or 1 but defaults to null

Environment

Mac, SQLServer

Activity

Show:

Justin Carter

October 21, 2015 at 6:49 AM

Since DB gateways in 6.1, to set a default constraint in the DB you should use `required="true"` and `default="someDefaultValue"`.

Omitting the `required` attribute or setting `required="false"` will allow NULLs, by design.

Geoff Bowers

April 7, 2013 at 1:31 AM

Blair has this issue been addressed by the new db gateways released in 6.1? If so, please close out the ticket.

Resize issue view side panel

Won't Fix

Details

Assignee

Blair McKenzie

Reporter

Gavin Stewart

Original estimate

Time tracking

No time logged2h remaining

Components

FourQ & ORM

Affects versions

6.0.1

Priority

Major

Parent

FC-2760 Improved COAPI/dbGateway tools

Created March 24, 2010 at 12:09 AM

Updated October 21, 2015 at 6:49 AM

Resolved October 21, 2015 at 6:49 AM