User Guide

332 Chapter 2: ColdFusion Tags
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.attachmentfiles 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.
To create a ColdFusion date/time object from the date-time string that is extracted from a mail
message in the
queryname.date column, use the following table:
Note: To set the default display format of date, time, number, and currency values, use the SetLocale
function.
Column name getHeaderOnly returns getAll returns
queryname.date yes yes
queryname.from yes yes
queryname.messagenumber yes yes
queryname.messageid yes yes
queryname.replyto yes yes
queryname.subject yes yes
queryname.cc yes yes
queryname.to yes yes
queryname.body no yes
queryname.textBody no yes
queryname.HTMLBody no yes
queryname.header yes yes
queryname.attachments no yes
queryname.attachmentfiles no yes
Locale How to create a ColdFusion date/time object from queryname.date
English (US) Use the
ParseDateTime function. If you specify the pop-conversion attribute, the
function adjusts the date/time object to UTC.
Other Extract the date part of string; pass it to the
LSParseDateTime function.