{"id":6,"date":"2008-05-22T20:52:41","date_gmt":"2008-05-23T02:52:41","guid":{"rendered":"http:\/\/www.n8williams.com\/devblog\/?p=6"},"modified":"2008-05-22T20:54:30","modified_gmt":"2008-05-23T02:54:30","slug":"coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","status":"publish","type":"post","link":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","title":{"rendered":"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns"},"content":{"rendered":"

I noticed when I was unit testing that when I was setting a reactor record field to zero (userrecord.setUsedFilespace(0)), and then saving the record, the database would not update the table’s value from null to zero.<\/p>\n

Turns out, as Chris pointed out, that if a table has a column that allows nulls, any zero value will automatically be saved as NULL. So this column,of type bigint, had no way of getting a zero value into it through reactor, which would always set the zero value to null.<\/p>\n

What we did was customize the userDAO. We changed the create and update methods. In the DAO folder of the project, the userDAO was edited. In the create and update methods we changed the code:<\/p>\n

\nnull=”#Iif(arguments.to.usedFilespace EQ 0 OR NOT Len(arguments.to.usedFilespace)\n<\/div>\n

TO<\/p>\n

\nnull=”#Iif(NOT Len(arguments.to.usedFilespace)\n<\/div>\n

And this allowed the updates and creates to use zero values. <\/p>\n","protected":false},"excerpt":{"rendered":"

I noticed when I was unit testing that when I was setting a reactor record field to zero (userrecord.setUsedFilespace(0)), and then saving the record, the database would not update the table’s value from null to zero. Turns out, as Chris pointed out, that if a table has a column that allows nulls, any zero value … Continue reading “Coldfusion Unity Reactor – Default behavior for zero values and nullable columns”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"yoast_head":"\nColdfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Coldfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages\" \/>\n<meta property=\"og:description\" content=\"I noticed when I was unit testing that when I was setting a reactor record field to zero (userrecord.setUsedFilespace(0)), and then saving the record, the database would not update the table’s value from null to zero. Turns out, as Chris pointed out, that if a table has a column that allows nulls, any zero value … Continue reading "Coldfusion Unity Reactor – Default behavior for zero values and nullable columns"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\" \/>\n<meta property=\"og:site_name\" content=\"The Dev Pages\" \/>\n<meta property=\"article:published_time\" content=\"2008-05-23T02:52:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-05-23T02:54:30+00:00\" \/>\n<meta name=\"author\" content=\"Nate Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@admin\" \/>\n<meta name=\"twitter:site\" content=\"@admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nate Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#article\",\"isPartOf\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\"},\"author\":{\"name\":\"Nate Admin\",\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757\"},\"headline\":\"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns\",\"datePublished\":\"2008-05-23T02:52:41+00:00\",\"dateModified\":\"2008-05-23T02:54:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\"},\"wordCount\":167,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757\"},\"articleSection\":[\"Coldfusion\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\",\"url\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\",\"name\":\"Coldfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages\",\"isPartOf\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/#website\"},\"datePublished\":\"2008-05-23T02:52:41+00:00\",\"dateModified\":\"2008-05-23T02:54:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/n8williams.com\/devblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/n8williams.com\/devblog\/#website\",\"url\":\"https:\/\/n8williams.com\/devblog\/\",\"name\":\"The Dev Pages\",\"description\":\"A knowledge base for web applications development (and beyond)\",\"publisher\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/n8williams.com\/devblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757\",\"name\":\"Nate Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19d7bc7602072ac846e912622704a628?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19d7bc7602072ac846e912622704a628?s=96&d=mm&r=g\",\"caption\":\"Nate Admin\"},\"logo\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/n8williams.com\",\"https:\/\/twitter.com\/admin\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Coldfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","og_locale":"en_US","og_type":"article","og_title":"Coldfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages","og_description":"I noticed when I was unit testing that when I was setting a reactor record field to zero (userrecord.setUsedFilespace(0)), and then saving the record, the database would not update the table’s value from null to zero. Turns out, as Chris pointed out, that if a table has a column that allows nulls, any zero value … Continue reading \"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns\"","og_url":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","og_site_name":"The Dev Pages","article_published_time":"2008-05-23T02:52:41+00:00","article_modified_time":"2008-05-23T02:54:30+00:00","author":"Nate Admin","twitter_card":"summary_large_image","twitter_creator":"@admin","twitter_site":"@admin","twitter_misc":{"Written by":"Nate Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#article","isPartOf":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns"},"author":{"name":"Nate Admin","@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757"},"headline":"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns","datePublished":"2008-05-23T02:52:41+00:00","dateModified":"2008-05-23T02:54:30+00:00","mainEntityOfPage":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns"},"wordCount":167,"commentCount":0,"publisher":{"@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757"},"articleSection":["Coldfusion"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#respond"]}]},{"@type":"WebPage","@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","url":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns","name":"Coldfusion Unity Reactor - Default behavior for zero values and nullable columns - The Dev Pages","isPartOf":{"@id":"https:\/\/n8williams.com\/devblog\/#website"},"datePublished":"2008-05-23T02:52:41+00:00","dateModified":"2008-05-23T02:54:30+00:00","breadcrumb":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/coldfusion-unity-reactor-default-behavior-for-zero-values-and-nullable-columns#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/n8williams.com\/devblog\/"},{"@type":"ListItem","position":2,"name":"Coldfusion Unity Reactor – Default behavior for zero values and nullable columns"}]},{"@type":"WebSite","@id":"https:\/\/n8williams.com\/devblog\/#website","url":"https:\/\/n8williams.com\/devblog\/","name":"The Dev Pages","description":"A knowledge base for web applications development (and beyond)","publisher":{"@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/n8williams.com\/devblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757","name":"Nate Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19d7bc7602072ac846e912622704a628?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19d7bc7602072ac846e912622704a628?s=96&d=mm&r=g","caption":"Nate Admin"},"logo":{"@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/n8williams.com","https:\/\/twitter.com\/admin"]}]}},"_links":{"self":[{"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/posts\/6"}],"collection":[{"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":0,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/posts\/6\/revisions"}],"wp:attachment":[{"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/media?parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/categories?post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/tags?post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}