{"id":8670,"date":"2020-11-23T15:51:56","date_gmt":"2020-11-23T23:51:56","guid":{"rendered":"https:\/\/minisoft.com\/support\/?p=8670"},"modified":"2020-11-23T15:51:57","modified_gmt":"2020-11-23T23:51:57","slug":"troubleshooting-data-type-mismatch","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/troubleshooting-data-type-mismatch\/","title":{"rendered":"Troubleshooting: Data type mismatch"},"content":{"rendered":"\n<p>A number of conditions might result in a <em>Data type mismatch<\/em> error in your eFORMz log. The most common cause of this error is numeric values that contain leading spaces, so eFORMz interprets the value as a string. For example, the following VendorID can result in a Data type mismatch error:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"209\" height=\"116\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch1.jpg\" alt=\"\" class=\"wp-image-8671\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch1.jpg 209w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch1-150x83.jpg 150w\" sizes=\"(max-width: 209px) 100vw, 209px\" \/><\/figure><\/div>\n\n\n\n<p>The solution is to add a Left trim function to remove leading spaces. Similarly, trailing spaces might result in the same error, so add a Right trim function to the variable:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"214\" height=\"168\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch2.jpg\" alt=\"\" class=\"wp-image-8672\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch2.jpg 214w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2020\/11\/DataTypeMismatch2-150x118.jpg 150w\" sizes=\"(max-width: 214px) 100vw, 214px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>A number of conditions might result in a Data type mismatch error in your eFORMz log. The most common cause of this error is numeric values that contain leading spaces, so eFORMz interprets the value as a string. For example, the following VendorID can result in a Data type mismatch error: The solution is to [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[657,656,545],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8670"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=8670"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8670\/revisions"}],"predecessor-version":[{"id":8673,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8670\/revisions\/8673"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=8670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=8670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=8670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}