Ask a Question related to Macromedia ColdFusion, Design and Development.
-
BWUK #1
CFMAIL problem - every nth message disappears
ISP is running CF 4, 5, 1, SP2
Discovered a problem recently whereby every 12th message sent from a list
never arrives, have been using the same code for many years and has not changed
since it was first implemented. The code used to reproduce the problem is:-
<CFQUERY NAME="GettheMail" DATASOURCE=#dsn# USERNAME=#usr# PASSWORD=#pwd#>
select * from tblAutoMail where (fldActivate= Yes) order by fldEmail
</CFQUERY>
<CFSET c=1>
<CFOUTPUT QUERY="GettheMail" group="fldEmail">
<cfmail to="catchall@test.co.uk"
from="Testing <test@test.co.uk>"
subject="#fldemail#">
</cfmail>
#c# #fldemail# <br>
<CFSET c = c + 1>
<CFQUERY NAME="AddEmail" DATASOURCE=#dsn# USERNAME=#usr# PASSWORD=#pwd#>
INSERT INTO tblTrace
(fldCounter, fldEmail)
VALUES ('#c#','#fldEmail#')
</CFQUERY>
</CFOUTPUT>
The output to the browser and records inserted into the trace table match the
number of records in the table so the recordset is correctly processed but
mysteriously every 12th message is not delivered, the live site uses the CFMAIL
tag slightly differently, ie <CFMAIL QUERY="GettheMail" to="#fldemail#", but
causes the same problem, no errors are reported by CF.
Have tested a similar routine using ASP and all the mesages arrived
succesfully, my ISP is a bit slow off the mark so I thought I would ask here.
Thanks
BWUK Guest
-
cfmail spool sending one message at a time
I have mx7 installed and a cfmail page sends files to the spool corectly. The spool is only sending out one message every 60 seconds or so.... -
cfmail query using form for input of message
There must be a way to do this--to search for a group who is to receive the email, let a user create a form message, and send to all those users.... -
cfmail query results in mail message
I am working on an alarm mail system that will send emails when data values in a DB reach or exceed certain values... I can put cfmail... -
Paging problem in VS.Net - datagrid disappears
I have a datagrid in VS.Net showing numeric paging and the first page of data is displayed. Clicking on any other of the page numbers results in the... -
Printing problem/ Layer pallette disappears
I bought Elements a couple of months ago and I wonder if I have a faulty disc. Two annoying problems exist. When I click on Print Preview there is...



Reply With Quote

