Databases
StackOverflow2013
Postsdbo
POIndividual mail sending does not work while mailing within loop works
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIndividual mail sending does not work while mailing within loop works
    primarykey
    data
    text
    <p>I have created a function that sends mail to my email id using different mail ids. The setting of the different mail ids are stored in mailpresets table. The problem is that when I send the mails using loop, the mails are received.</p> <pre><code>&lt;cffunction name="processFormSubmission"&gt; &lt;cfset template = model("mailpreset").findAll() /&gt; &lt;cfloop query="template"&gt; &lt;cfmail from="#template.fromEmail#" to="test@test.com" server="#template.serverHostName#" username="#template.serverUserName#" port="#template.serverPort#" password="#template.serverPassword#" subject="Mail from #template.fromEmail#" type="html" usessl="#template.useSSL#" usetls="#template.useTLS#"&gt; #template.fromEmail# &lt;/cfmail&gt; &lt;/cfloop&gt; &lt;cfabort&gt; &lt;/cffunction&gt; </code></pre> <p>But when I use single mail preset for sending mail the mail does not get sent. The mail get send with the same mailpreset when send using the previous method.</p> <pre><code>&lt;cffunction name="processFormSubmission"&gt; &lt;cfset template = model("mailpreset").findAll(where="id=7") /&gt; &lt;cfmail from="#template.fromEmail#" to="test@test.com" server="#template.serverHostName#" username="#template.serverUserName#" port="#template.serverPort#" password="#template.serverPassword#" subject="Mail from #template.fromEmail#" type="html" usessl="#template.useSSL#" usetls="#template.useTLS#"&gt; #template.fromEmail# &lt;/cfmail&gt; &lt;cfabort&gt; &lt;/cffunction&gt; </code></pre> <p>What is the problem behind it?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USScott Stroz
    1. USPankaj
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThe second set of code is cut off, are you sure that 'template' is being set correctly? Do you see the mail in the mail spool? Is there an entry in the mail log? You could wrap a catch-try around the single mail, fire it off to a log, and see if it trips something
      singulars
      1. POIndividual mail sending does not work while mailing within loop works
      1. USDana Kowalski
    2. COwho knows? What's in your mail log? Are the mails ending up in your ColdFusion undelivered mail folder, or are they being bounced back by your SMTP server? In your code your 2nd example doesn't include `<cfset template = model("mailpreset").findAll() />` - are you still doing that? Also you should var-scope all variables inside your functions, i.e. `template`
      singulars
      1. POIndividual mail sending does not work while mailing within loop works
      1. USduncan
    3. COFYI: Fixed code formatting so the second example is fully visible.
      singulars
      1. POIndividual mail sending does not work while mailing within loop works
      1. USLeigh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload