RE: [DFW CFUG] cfpop

Mon, 17 Jul 2006 13:49:51 -0700

Thanks – I was able to get a working model of a check in/check out system working last night and it seems to work ok for me.  Now I just need to see what the users think.

 

Thanks,

Tim

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Woestman
Sent: Monday, July 17, 2006 8:30 AM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: RE: [DFW CFUG] cfpop

 

Tim,

 

I have a project that uses mail to send information that may be processed by multiple servers on the back end.  I used an automated process that checks for incoming emails, and if found moves them to a SQL table for further processing.  By putting them in the SQL table you can do things like flag them as being processed etc.  I think you will find that by just using the pop server as a way to get the feedback into a table you will find the rest of the application much easier (and likely more reliable).

 

I hope you find this useful,

Tom

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Starling
Sent: Sunday, July 16, 2006 6:12 PM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: RE: [DFW CFUG] cfpop

 

ArrayToList to list worked on my first issue.  Any feedback on the other issue would be very appreciated.

 

Thanks,

Tim

 

Tim Starling
Project Manager Web
Global Aid Network
A ministry of Campus Crusade for Christ International
972-234-0800, extension 1335
www.gainusa.org

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Starling
Sent: Sunday, July 16, 2006 5:35 PM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: [DFW CFUG] cfpop

 

I hope this is very simple and I’m just overlooking the obvious.  I am using cfpop to go out and get e-mail from an account where tech support messages are sent.  The messages are then saved in a table. Those two items work fine….  I want to then delete those messages from the account.  Cfpop has that option but I am having trouble creating the list of messagenumber’s from the original cfpop query into a text list that I can populate into the second cfpop on the page that will delete all the retrieved e-mails.  I would rather not loop of the query creating multiple cfpop calls deleting them one at a time if I can help it.

 

Here is my sequence:

 

  • Cfpop to get the e-mails

 

  • Cfquery to insert the data into the database

 

  • Cfpop to delete the downloaded e-mails from the server (where I am having problems)

 

 

 

<cfpop server="mail.company.com"
  username=#username#
  password=#password#
  action="">
  messagenumber="#need my comma delimited list here#">


 



I thought I would use cfoutput with cfset to create a comma
delimited list but that didn’t work the way I tried it.  



 



Anyone have a good solution that I’m not thinking of?



 



Also, on a separate note…. Has anyone found a good way
to make sure that users don’t open the same record at the same time to
work on it.  There are three techs that will be using the system and they
can all initially see the same records in a cfgrid.  When one opens a
record we don’t want someone else to be able to open that same record. 
My current thought is to have a field in the record that is a time stamp that
would be added when the person opens up the detail form page.  Then if
someone tried to open that record in the detail page within a certain time
frame, they would see a lock and the user that has it locked by querying that
date and doing a dateDiff to see if it was within a certain time frame.
 Has anyone done something that would be a little more effective?



 



Thanks,



Tim



Tim Starling

Project Manager Web

Global Aid Network

A ministry of Campus Crusade for Christ International

972-234-0800, extension 1335

www.gainusa.org




 












This e-mail message has been scanned for Viruses and Content and
cleared by MailMarshal - For more
information please visit www.marshalsoftware.com 





















This e-mail message has been scanned for Viruses and Content and
cleared by MailMarshal - For more
information please visit www.marshalsoftware.com
This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com 
_______________________________________________
Reply to DFWCFUG: 
  [email protected]
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/

Reply via email to