LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-b14.htm

coldfusion/6.1/htmldocs/tags-b14.htm

hlevin — 2005-09-07T13:25:19

It appears that the old bug from CF4.5 is still present in CFMX6.1. cfpop does not see rfc822 embedded messages. While outlook sees the rfc822 content as an attachment, CFPOP ignores that part alltogether. Wonder if there is a workaround or a some hidden variable which can display the entire raw content of the email message with all headers and message boundaries.

coldfusion/6.1/htmldocs/tags-b14.htm

Hutz — 2005-08-05T15:35:09

With field names like "Date" and "From", the query returned by CFPOP is not suitable at all for a query of a query, "Date" and especially "From" being SQL reserved words.

Image wanting to get only email messages dated within the last hour for an rss type application: should be easy enough, right?

SELECT *
FROM popresult
WHERE DATE < #Now()-1/24#

The SQL will crash on the word "Date" -- even though that's the name of the field, you can't use it...

Image wanting to scan subjects of emails only from some specific person:

SELECT Subject, From
FROM popresult
WHERE From = 'specific person'

What's poor SQL to make of all those "from"s? Which one is the SQL syntax one, and which one is the field name?

A little more care should have gone into naming the returned fields; something like POPDate and POPFrom maybe....

coldfusion/6.1/htmldocs/tags-b14.htm

bigzman — 2005-06-06T10:39:11

The CFPOP tag seems to be handling incorrectly DNS resolution of round robin to more than one host. If the server attribute in the cfpop is set to a domain name pointing to more than one IP in the DNS, the CFPOP throws an exception javax.mail.MessagingException: Connect failed;coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters(details below).

When the server is set to either any of the IP addresses from the round robin or the corresponding domain names with 1-to-1 mapping, CFPOP works fine. I have observed this exception on CFMX 6.1 in j2ee/jrun4 config under Linux RedHat AS 3. Seems to work fine under J2EE setup on Win XP Pro.

Any comemnts anyone?

--
An exception occurred when setting up mail server parameters.This exception was caused by: javax.mail.MessagingException: Connect failed; nested exception is: java.net.ConnectException: Connection refused. The specific sequence of files included or processed is: /www/pop.cfm "
coldfusion.mail.MailSessionException: An exception occurred when setting up mail server parameters.
at coldfusion.tagext.net.PopTag.doStartTag(PopTag.java:373)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876)
at cfpop2ecfm2126649301.runPage(/www/pop.cfm:12)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

coldfusion/6.1/htmldocs/tags-b14.htm

halL — 2004-12-16T08:59:27

There is a bug in ColdFusion MX (fixed in the upcoming release) that the value returned in the UID field is not the messge UID, but the message ID.
I have tested your example code in ColdFusion MX 6.1 and I do get the message ID in the UID field.

coldfusion/6.1/htmldocs/tags-b14.htm

Abinidi — 2004-12-07T21:32:58

How do you get queryname.uid to show up even? Or is that part of the enhancement?

server="mail.myserver.com"
username="mypics@myserver.com"
password="password">
total: #pics.recordCount#

#subject# - #htmleditformat(to)# - #messagenumber# - #pics.uid#

I get a blank uid...

coldfusion/6.1/htmldocs/tags-b14.htm

sweetnevil — 2004-10-15T13:29:03

While I assume that in order to run CFPOP over TLS/SSL, all one would do is set port="995" in the CFPOP tag... however the documentation makes no mention whatsoever of CFPOP's SSL capabilities....

I see this as a fairly serious omission, since SSL and security are ever-more critical aspects of web development.

Any additions to this portion of the document would be superb!

coldfusion/6.1/htmldocs/tags-b14.htm

jrunrandy — 2004-10-13T19:12:15

I have added enhancement request 58141 into our bug database.

coldfusion/6.1/htmldocs/tags-b14.htm

Kerrdo — 2004-10-13T18:45:53

Why dosen't cfpop support action="getUIDOnly"
Is this something that is to difficult to impliment?
Is there any chance of MM releasing an update for this?

coldfusion/6.1/htmldocs/tags-b14.htm

jrunrandy — 2004-06-14T12:48:11

Mettedraq, ColdFusion does not support what you are asking for.

coldfusion/6.1/htmldocs/tags-b14.htm

Mettedraq — 2004-06-14T10:20:33

I have one big problem.. and I haven't seen anyone ask about it yet..
I am able to save attachments from pop and readbinary the file and save it locally to cfmail the attachment of an email.. to basically forward the email..

problems..
1) I cannot get the ".msg" - outlook message file - to save as an attachment so I don't loose any attachments that it might have within itself. Which would be nice to just slam the text into the body and save the attachments.
2) There is no mention of this anywhere!!! WHY?!?!?!! shouldn't an attachment still be an attachment after receiving it through cfpop.

Please find any information on this and post it ASAP.. I am working on an email splitter in coldfusion to allow someone to work with fax images over a web site.. rather than through adobe acrobat and outlook..

let me know any info through this site.. thanx..

Mettedraq

coldfusion/6.1/htmldocs/tags-b14.htm

2004-05-21T04:17:01

When i recibed attachments with CFPOP and the file names have special characters, they are saved in my Linux Server with other characters, and then i can't access to them.

Is there any way to saved theese files with a determinate codification?

Thanks

coldfusion/6.1/htmldocs/tags-b14.htm

jrunrandy — 2003-11-06T06:13:59

There is a big mistake and a little mistake in the example:
The big mistake is that "server" is a reserved word, starting in cfmx. So change the variable "server" to something like "popserver".
The little mistake is that the form variables in the first part of the example should all be prefixed with the form. prefix

coldfusion/6.1/htmldocs/tags-b14.htm

brianatvfive — 2003-10-18T12:10:50

This page has a typo that says qryname.attachments twice; qryname.attachments is the tab separated list of attachments and qryname.attachmentfiles is the list of filenames that you can process with CFFILE.