Doug, your guess that the email gets sent before the new PDF gets built rings true to me. It would explain the problem on my client's server, as well as the fact that it's not happening to me right now testing the system working on my own PC as localhost. It jogs my memory that my coworker experienced a similar problem back about 2001, when I was programming ColdFusion in New York City. (?New York City!?? Get a rope!) Dean, doesn't it make sense to you that the e-mail could get sent before the second version of the file gets built, so it merely picks up what it finds on the disk , namely, the earlier version of the file? Actually, come to think of it, that would not be an instance of caching. Ajas, I don't know, but it seems to me that saving the PDF into a SQL Server column might have the same problem as that described by Doug: if these operations can be performed asynchronously, then wouldn't it be possible that cfmail could grab the old value from the SQL Server column (presumably via its 'query=' parameter?) before my SQL Server update statement stuffs the new value into it? Howard, No, I didn't mean the office manager might get mixed up on which file is which - he's reasonably computer literate, and knows perfectly well that the one on top was sent later (Whoops! It just occurred to me that that might not always be true if there's a glitch in the e-mail process...). Anyway, though, what I did mean is that it's simply the older version of the file that gets attached to the e-mail. Your idea of sending a link seems like a good one, and I may try that but ... >>> Naming the PDF by the Job Number instead of by the reporter's ID is necessary of regardless of whether I attach the file or send a link. In either case, I'd be writing the file to disk. If I were to delete any old copy beforehand, what are the chances that (if this asynchrous story is true) cfmail would fail to find the file when it looks for it and throw an error? Peyton -----Original Message------------------------------------------------------------------ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- |
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Dean H. Saxe
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Dean H. Saxe
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Douglas Knudsen
- Re: [ACFUG Discuss] Another CFMAIL Problem Ajas Mohammed
- Re: [ACFUG Discuss] Another CFMAIL Problem Dean H. Saxe
- Re: [ACFUG Discuss] Another CFMAIL Problem Howard Fore
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Dawn Hoagland
- Re: [ACFUG Discuss] Another CFMAIL Problem Ajas Mohammed
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Douglas Knudsen
- RE: [ACFUG Discuss] Another CFMAIL Problem Charlie Arehart
- Re: [ACFUG Discuss] Another CFMAIL Problem Howard Fore
- RE: [ACFUG Discuss] Another CFMAIL Problem Peyton Todd
- Re: [ACFUG Discuss] Another CFMAIL Problem Douglas Knudsen