{"id":352,"date":"2010-08-23T15:34:41","date_gmt":"2010-08-23T19:34:41","guid":{"rendered":"http:\/\/erics-test-lab.com\/?p=352"},"modified":"2010-08-23T15:34:41","modified_gmt":"2010-08-23T19:34:41","slug":"reserved-words-and-coldfusion","status":"publish","type":"post","link":"https:\/\/www.esearing.com\/v2010\/2010\/08\/reserved-words-and-coldfusion\/","title":{"rendered":"Reserved words and Coldfusion"},"content":{"rendered":"<p>I ran into an interesting issue today. I had form variables whose names ended in <strong>_date<\/strong>. When i was testing I output the form variables using CFDUMP and they appeared in the list of variables passed. <\/p>\n<p>However when trying to insert the list of variables into a database all of my _date variables were missing.<\/p>\n<p>I soon learned that when you use the FORM Scope you can not use variables ending in _date. #FORM.FIELDNAMES# will not contain these fieldsnames so looping does not capture all of them. I had to rename my Form Elements to _dt to be sure they would be passed.<\/p>\n<p>You can read more about coldfusion naming conventions here <a href=\"http:\/\/www.oreillynet.com\/pub\/a\/oreilly\/web\/news\/coldfusion_0701.html\">http:\/\/www.oreillynet.com\/pub\/a\/oreilly\/web\/news\/coldfusion_0701.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I ran into an interesting issue today. I had form variables whose names ended in _date. When i was testing I output the form variables using CFDUMP and they appeared in the list of variables passed. However when trying to &hellip; <a href=\"https:\/\/www.esearing.com\/v2010\/2010\/08\/reserved-words-and-coldfusion\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,16,21],"tags":[],"class_list":["post-352","post","type-post","status-publish","format-standard","hentry","category-code","category-coldfusion","category-problems-fixes"],"_links":{"self":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/comments?post=352"}],"version-history":[{"count":0,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}