[DFW CFUG] cfpop

[Tim Starling]

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

_______________________________________________
Reply to DFWCFUG: 
  List@list.dfwcfug.org
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/