{"id":3,"date":"2008-05-21T23:45:12","date_gmt":"2008-05-22T05:45:12","guid":{"rendered":"http:\/\/www.n8williams.com\/devblog\/?p=3"},"modified":"2008-05-22T20:45:38","modified_gmt":"2008-05-23T02:45:38","slug":"accessing-data-explicitly-in-a-coldfusion-query-object","status":"publish","type":"post","link":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object","title":{"rendered":"Accessing data in a coldfusion query object"},"content":{"rendered":"

The syntax is:<\/p>\n

\nqueryvariable.columnname[rownumber]\n<\/div>\n

It would seem that the query datatype is an array of structs. Indeed as I read some posts online, I discovered a query is like <\/em> an array of structs. But the query object is a special data type in coldfusion, like an array or a struct. See the Adobe article linked below.<\/p>\n

I don’t know why this was so hard to find in the livedocs, or why the ColdFusion documentation for cfquery didn’t have any useful links, but Joel was able to point out to me right off that you can access the data in the rows\/fields of a cfquery easily.<\/p>\n

I’ll quote Adobe’s livedocs here, in a buried artilce. I ended up finding this useful page with a google search. <\/p>\n

“A query object, sometimes referred to as a query, query result, or record set, is a complex ColdFusion data type that represents data in a set of named columns, similar to the columns of a database table.”<\/p>\n

“You reference query columns by specifying the query name, a period, and the column name”<\/p>\n

“You can access query columns as if they are one-dimensional arrays.” <\/p>\n

\nEx:<cfset myVar = myQuery.Employee[2]>”\n<\/div>\n

http:\/\/livedocs.adobe.com\/coldfusion\/8\/htmldocs\/help.html?content=Variables_17.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The syntax is: queryvariable.columnname[rownumber] It would seem that the query datatype is an array of structs. Indeed as I read some posts online, I discovered a query is like an array of structs. But the query object is a special data type in coldfusion, like an array or a struct. See the Adobe article linked … Continue reading “Accessing data in a coldfusion query object”<\/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":"\nAccessing data in a coldfusion query object - 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\/accessing-data-explicitly-in-a-coldfusion-query-object\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accessing data in a coldfusion query object - The Dev Pages\" \/>\n<meta property=\"og:description\" content=\"The syntax is: queryvariable.columnname[rownumber] It would seem that the query datatype is an array of structs. Indeed as I read some posts online, I discovered a query is like an array of structs. But the query object is a special data type in coldfusion, like an array or a struct. See the Adobe article linked … Continue reading "Accessing data in a coldfusion query object"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\" \/>\n<meta property=\"og:site_name\" content=\"The Dev Pages\" \/>\n<meta property=\"article:published_time\" content=\"2008-05-22T05:45:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-05-23T02:45:38+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\/accessing-data-explicitly-in-a-coldfusion-query-object#article\",\"isPartOf\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\"},\"author\":{\"name\":\"Nate Admin\",\"@id\":\"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757\"},\"headline\":\"Accessing data in a coldfusion query object\",\"datePublished\":\"2008-05-22T05:45:12+00:00\",\"dateModified\":\"2008-05-23T02:45:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\"},\"wordCount\":216,\"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\/accessing-data-explicitly-in-a-coldfusion-query-object#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\",\"url\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\",\"name\":\"Accessing data in a coldfusion query object - The Dev Pages\",\"isPartOf\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/#website\"},\"datePublished\":\"2008-05-22T05:45:12+00:00\",\"dateModified\":\"2008-05-23T02:45:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/n8williams.com\/devblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Accessing data in a coldfusion query object\"}]},{\"@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":"Accessing data in a coldfusion query object - 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\/accessing-data-explicitly-in-a-coldfusion-query-object","og_locale":"en_US","og_type":"article","og_title":"Accessing data in a coldfusion query object - The Dev Pages","og_description":"The syntax is: queryvariable.columnname[rownumber] It would seem that the query datatype is an array of structs. Indeed as I read some posts online, I discovered a query is like an array of structs. But the query object is a special data type in coldfusion, like an array or a struct. See the Adobe article linked … Continue reading \"Accessing data in a coldfusion query object\"","og_url":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object","og_site_name":"The Dev Pages","article_published_time":"2008-05-22T05:45:12+00:00","article_modified_time":"2008-05-23T02:45:38+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\/accessing-data-explicitly-in-a-coldfusion-query-object#article","isPartOf":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object"},"author":{"name":"Nate Admin","@id":"https:\/\/n8williams.com\/devblog\/#\/schema\/person\/1c31624786b5382f1a811f0a01985757"},"headline":"Accessing data in a coldfusion query object","datePublished":"2008-05-22T05:45:12+00:00","dateModified":"2008-05-23T02:45:38+00:00","mainEntityOfPage":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object"},"wordCount":216,"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\/accessing-data-explicitly-in-a-coldfusion-query-object#respond"]}]},{"@type":"WebPage","@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object","url":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object","name":"Accessing data in a coldfusion query object - The Dev Pages","isPartOf":{"@id":"https:\/\/n8williams.com\/devblog\/#website"},"datePublished":"2008-05-22T05:45:12+00:00","dateModified":"2008-05-23T02:45:38+00:00","breadcrumb":{"@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/n8williams.com\/devblog\/coldfusion\/accessing-data-explicitly-in-a-coldfusion-query-object#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/n8williams.com\/devblog\/"},{"@type":"ListItem","position":2,"name":"Accessing data in a coldfusion query object"}]},{"@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\/3"}],"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=3"}],"version-history":[{"count":0,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/posts\/3\/revisions"}],"wp:attachment":[{"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/media?parent=3"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/categories?post=3"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/n8williams.com\/devblog\/wp-json\/wp\/v2\/tags?post=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}