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
