thanks for the note. I have tested as much as I can for now. I ran the test 10 times on my test server with the data that had the problem...result NO PROBLEM. I ran it 5 times on the main server changing the to: to me: result NO PROBLEM. I have added a word wrap function around the emailtext....I have changed the wrap to wrap=virtual...I have added me as a recipient to all blast emails. If it happens again, I will see it first hand. My guess is I will not see it.
thanks to all of you who tried to help. if I ever do find the gremlin I will let everyone know. kaigler At 02:04 PM 3/27/2002 -0800, you wrote: >Here are some ideas for debugging this, > >1) Wrap your two queries in a cftransaction tag, to >see if the one that is pulling out the data may be >screwing up somewhere while the one that pulls the >email addresses is still working fine. > >2) This is a question: Is the code you quoted exactly >how the email is generated? I only ask this because >it looks like the body of the email is a separate >field from the domain link. > >3) You are putting in HTML characters if you are >embedding a link in the message, so try using >type="html" and see if that changes anything > >4) CFschedule... I have had many problems getting it >to fire off templates using cfmail, so I feel your >pain, could you create a batch file test to send out >say 50 or 100 of just the sample emails to yourself >from the database? It might be something that is >sporadic, but without isolating the problem, you >wouldn't know. > >Hope that helps, I am not a guru at this, just my >first thoughts. > >--- Dylan Bromby <[EMAIL PROTECTED]> wrote: > > Is there something in your table design that's > > truncating the email when > > it's stored? > > > > -----Original Message----- > > From: Bill Kaigler [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, March 27, 2002 8:09 AM > > To: CF-Server > > Subject: RE: cfmail issues > > > > > > so does that mean you do not see a problem with the > > code? > > > > Virtual is the default setting for WRAP. > > > > I will add it if this will make a difference. > > > > I have tried about 20 times to send the email > > examples to this list but > > it > > kept getting rejected.......I will try again. > > > > > > here is an example of the full email that was being > > sent out: > > > > > > We wanted to keep you updated with the current > > situation. John Doe has > > written an article for our website regarding how > > your CRS contracts > > might > > be affected with zero commissions. We thought it had > > great information > > and > > wanted to get it to you right away. Please click on > > the link below to > > read > > > > domain link > > > > Thanks, > > Your Board of Directors > > > > > > > > This is what was reported to have been delivered: > > > > > > domain link > > > > Thanks, > > Your Board of Directors > > > > > > The entire paragraph is missing before the link. > > Now, when I look at the > > > > data in the database the entire email is there. This > > information is not > > being sent out as an html message. There is NO html > > embedded. > > > > You mentioned adding the message to go out as HTML. > > If you have no html > > embedded and you send out a message as html does it > > make a difference? > > That > > is, does it add extra formatting to the message that > > would not be there > > otherwise? > > > > > > > > > > > > > > At 07:57 AM 3/27/2002 -0800, you wrote: > > >I'm pretty sure the WRAP attribute requires a value > > such as > > >OFF|HARD|VIRTUAL etc. > > > > > >-----Original Message----- > > >From: Bill Kaigler [mailto:[EMAIL PROTECTED]] > > >Sent: Wednesday, March 27, 2002 7:32 AM > > >To: CF-Server > > >Subject: RE: cfmail issues > > > > > > > > >Like I said, I do not think i t is the code since I > > can resend exactly > > >what the client sends and get the full email, but > > it is....very simple. > > > > > >Let me add that the info is saved in a MySQL > > database into a longtext > > >type. The textarea is defined as follows: > > > > > ><textarea name=message cols=65 rows=15 > > wrap></textarea> > > > > > >this is saved into the sendemailmain table in the > > longtext type > > >metnioned above. a batch job then reads the code > > below. > > > > > > > > ><cfquery datasource=#dbname# name=getemailtosend> > > >Select * from sendemailmain > > >where refnbr = #refnbr# > > ></cfquery> > > > > > ><cfoutput query=getemailtosend> > > ><cfset sendsubject = "#emailsubject#"> > > ><cfset sendemailnbr = "#emailnbr#"> > > ><cfset sendfrom = "#emailfrom#"> > > ><cfset sendtext = "#emailtext#"> > > ><cfset sendattachment = "#attachment#"> > > ></cfoutput> > > > > > ><cfif getemailtosend.recordcount gt 0> > > ><cfquery datasource=#dbname# name=getemaillist> > > >Select * from sendemaillist > > >where emailnbr = #sendemailnbr# > > ></cfquery> > > > > > ><cfoutput query=getemaillist> > > ><cfset sendemailto = "#emailaddress#"> > > > > > ><CFMAIL FROM="#getassnname.name# > > <#getassnname.email#>" > > >TO="#sendemailto#" SUBJECT="#sendsubject#"> > > > > > >#sendtext# > > > > > > > > ></cfmail> > > > > > ></cfoutput> > > > > > ></cfif> > > > > > > > > > > > >At 07:19 AM 3/27/2002 -0800, you wrote: > > > >Some ideas: > > > > > > > >Assuming you're using a TEXTAREA to creat the > > mail body, try using > > > >the WRAP="VIRTUAL" attribute/value pair. > > > > > > > >Also, can you post the CFMAIL code? > > > > > > > >I've got 50,000 webmail accounts using CFMAIL > > creating mail of > > > >various sizes and haven't seen this problem in 3 > > years of operation > > > >so I don't think it's a CF bug per se. I did have > > this problem quite > > > >some time ago...maybe '97...and that was resolved > > using the WRAP > > > >attribute if I remember correctly. > > > > > > > > > > > > > > > >-----Original Message----- > > > >From: Bill Kaigler > > [mailto:[EMAIL PROTECTED]] > > > >Sent: Wednesday, March 27, 2002 7:10 AM > > > >To: CF-Server > > > >Subject: Re: cfmail issues > > > > > > > > > > > >that is not the issue. my lines are not more > > than 1024. plus it is > > > >not > > > > > > > >the end of the lines it is the beginning. > > > > > > > >kaigler > > > > > > > >At 10:38 AM 3/27/2002 +0100, you wrote: > > > > >Bill Kaigler wrote: > > > > > > > > > > > > I have members that say when they send > > emails out sometimes the > > > > > > first paragraph (it is always the first part > > of the email) is > > > > > > truncated. If I look at the table record I > > can see that all the > > > > > > > > information is there, so I can remove the > > possibility that the > > > > > > problem exists before the email is sent. > > Knowing that cfmail > > > > > > will > > > > > > > > > send bad email address to the undeliv folder > > I appended a bad > > > > > > email address to each batch being sent out. > > If >=== message truncated === > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Movies - coverage of the 74th Academy Awards� >http://movies.yahoo.com/ > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
