close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

sending emails to recordset - adding dynamic field to Subject line

Thread began 2/02/2022 8:16 am by MWilson | Last modified 4/01/2022 8:56 am by Ray Borduin | 266 views | 16 replies |

MWilson

sending emails to recordset - adding dynamic field to Subject line

Hi Ray, I have an automated email which sends by looping through a recordset. All working fine, however if I add a dynamic value into the Subject field it always shows the value from the first record it finds and doesn't loop through. Dynamic values included in the email body are all correct. How would I fix the attached page so that the subject line will correctly include the info from the relevant record?

Sign in to reply to this post

Ray BorduinWebAssist

Thank you. I used your file to identify and fix an issue with the extension. I've updated the WA_email.php file to address the problem. If you re-install databrige then the file will be updated on your system. For now I have also attached the updated file so you overwrite and test it manually.

Attached Files
WA_Email.php
Sign in to reply to this post
Did this help? Tips are appreciated...

MWilson

Thanks for this, thought I was missing something really obvious! However there's no file attached - could you attach it so that I don't have to reinstall?

Sign in to reply to this post

Ray BorduinWebAssist

It should be in the previous thread, not attached to the email.

Sign in to reply to this post
Did this help? Tips are appreciated...

MWilson

Sorry yes, I see it now - will run a couple of tests and confirm it's working!

Sign in to reply to this post

MWilson

The subject line is now showing the correct info, however I noticed that two duplicate records are being written to the database - can't see what might be causing that?

Sign in to reply to this post

Ray BorduinWebAssist

I'd have to debug it. It could be the page loaded twice, or the recordset is returning duplicate records.

Sign in to reply to this post
Did this help? Tips are appreciated...

MWilson

I think it is because the page is sometimes reloading or refreshing - I usually run this via a scheduled task on the server but for testing purposes I'm loading it in the browser. I tried loading it in a different browser and it only created one database record so looks like it's fine. Thanks again.

Sign in to reply to this post

MWilson

Problem with the updated WA_Email.php file - quite urgent!

Hi Ray, I've just been made aware of an issue with the above file that you kindly updated for me which I think is probably the same issue as I had with the dynamic subject line. When the emails are being sent from a recordset, the cc email is being sent to the first record in the recordset, not the one linked to the correct record. So for example, the email code is:

$Email->addToFromRS("rsReminders","user_email");
$Email->addCCFromRS("rsReminders","EmailCopy");

The first email in the loop goes to the correct people, but the second and subsequent emails all get cc'd to the EmailCopy address in the first record. Hope you can help quite urgently as I have a bunch of these email scripts that run via a scheduled task every day at midday and I want to sort it out before tomorrow! I've attached a sample email page.

Sign in to reply to this post

Ray BorduinWebAssist

I see. It doesn't really work like that by default. You would have to hand code to get that working and put things in a different order in the code. Try this:

php:
<?php

if ("" === "")     {  //WA Universal Email (hand coded)
  
$Email = new WA_Email("event-reminder-email");
  
$Email->From "Paradigm <info@paradigm.co.uk>";
  
$Email->addToFromRS("rsReminders","user_email");  
  
$Email->BodyFile "../../../webassist/email/diary-regdata-reporting-half-year.php";
  if (
function_exists("rel2abs") && $Email->Redirect$Email->Redirect $Email->Redirect?rel2abs($Email->Redirect,dirname(__FILE__)):"";
  for (
$emailGroup=0$emailGroup<sizeof($Email->To); $emailGroup++) {
    
$Email->CC = array();
    
$Email->addCC($rsReminders->getColumnVal("EmailCopy",false));
    
$Email->Subject "Compliance Diary Reminder - RegData Reporting (Half Year)";
    
$Email->onSend = new Email_Log("insert","calendar_reminders","Email",$Composite);
    
$Email->onSend->Query->bindColumn("Email""s""".($rsReminders->getColumnVal("user_email"))  ."""WA_BLANK");
    
$Email->onSend->Query->bindColumn("Phone""s""".($rsReminders->getColumnVal("PhoneNo"))  ."""WA_BLANK");
    
$Email->onSend->Query->bindColumn("DisplayName""s""".($rsReminders->getColumnVal("display_name"))  ."""WA_BLANK");
    
$Email->onSend->Query->bindColumn("EventName""s""".($rsReminders->getColumnVal("EventName"))  ."""WA_BLANK");
    
$Email->send($emailGroup);
  }
  
$Email->close();
}
?>



I moved the CC line into the loop that sends the email so that it gets reset for every email and I can set it to the recordset value manually inside the loop so it will send to the corresponding row. I think that will work.

Sign in to reply to this post
Did this help? Tips are appreciated...
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...