hat is something but tell me how that could cause a problem...... - the person fills out a form and it is saved to the mysql database. if I look at the data on the database it is all there. (less than 1024 bytes on a line). - cfschedule runs every 15 minutes reads the table and builds the email from the database - all (the two or three that are not delivered) of the undeliv folder mail has the full email listed
- this is totally random. I have more than 70 clients and all send out cumulative blasts of about 4-5000 emails a day. Only 5 have complained about this. They usually send out a second message apologizing for the bad email and the second one goes out fine. thanks again for the discussion. kaigler At 11:51 AM 3/27/2002 -0500, you wrote: >Don't know if this helps but we had a similar problem before and it turned >out to be a problem with the persons webbrowser. > >Steve > >----- Original Message ----- >From: "Dylan Bromby" <[EMAIL PROTECTED]> >To: "CF-Server" <[EMAIL PROTECTED]> >Sent: Wednesday, March 27, 2002 11:51 AM >Subject: RE: cfmail issues > > > > 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 I look at this > > > > > > email in the undeliv folder the entire message exists. If I > > > > > > change the x-cf-to (which exists in the cfmail file): to my > > > > > > email address and then move it to the Spool directory, the email > > > > > > > > is sent > > > > > > > > > out fine. > > > > > > > > > >Wrapping/truncating of long lines. Try cf_wrap from the DevEx. > > > > > > > > > >Jochem > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
