User Guide

cfpop 269
cfpop query variables
The following table describes the variables that provide information about the query that is
returned by
cfpop:
Query message header and body columns
The following table lists the message header and body columns that are returned if action =
"
getHeaderOnly" or "getAll":
If the mail message includes a part with a Content-Type of text/plain, the queryname.textBody
column contains the part’s message content. If the mail message includes a part with a Content-
Type of text/HTML, the queryname.HTMLBody column contains the part’s message content. If
no Content-Type matches these types, the columns are empty. The queryname.Body column
always contains the first message body found.
The queryname.attachments column contains a tab-separated list of all the attachment names.
The queryname.attachments column contains a tab-separated list of the locations of the
attachment files. Use the
cffile tag to delete these temporary files when you have processed
them.
Variable names Description
queryname.recordCount Number of records returned by query
queryname.currentRow Current row that
cfoutput is processing
queryname.columnList List of column names in query
queryname.UID Unique identifier for the e-mail message file
Column name getHeaderOnly returns getAll returns
queryname.date yes yes
queryname.from yes yes
queryname.messagenumber yes yes
queryname.replyto yes yes
queryname.subject yes yes
queryname.cc yes yes
queryname.to yes yes
queryname.body not available yes
queryname.textBody not available yes
queryname.HTMLBody not available yes
queryname.header not available yes
queryname.attachments not available yes
queryname.attachmentfiles not available yes