UE v4.0 - Success Or Failure Log Bindings

I have a successful mass mailing newsletter that I need to make a slight addition to the email_log table. The scripting below is rather rigid and although I can manually edit it, if I return to the behavior in DW, it will revert back to the original settings and delete my edits.

//Start Log Bindings
  //Success Or Failure
  $MailLogBindings->SuccessOrFailure->ToDo = "insert";
  $MailLogBindings->SuccessOrFailure->Connection = "email";
  $MailLogBindings->SuccessOrFailure->TableName = "email_log";
  $MailLogBindings->SuccessOrFailure->EmailColumn = "EmailTo";
  $MailLogBindings->SuccessOrFailure->ColumnList = array("EmailTo", "EmailFrom", "EmailSubject", "EmailError", "EmailStatus");
  $MailLogBindings->SuccessOrFailure->TypeList = array("',none,''", "',none,''", "',none,''", "',none,''", "',none,''");
  $MailLogBindings->SuccessOrFailure->ValueList = array("".$_SESSION["waue_WA_newsletter_1_To"]  ."", "".$_SESSION["waue_WA_newsletter_1_From"]  ."", "".$_SESSION["waue_WA_newsletter_1_Subject"]  ."", "".$_SESSION["waue_WA_newsletter_1_Log"]  ."", "".$_SESSION["waue_WA_newsletter_1_Status"]  ."");

I want to added the RecID field from my email address table. (see JPG below).

What would you recommend to better control this specific function of the behavior?

When you edit the Universal Email server behaviors settings, you can also edit the logging functions. and set it to store that value directly in the wizard.

Jason,

Thanks for your response.

Let me be a little more visual with my question....

MySQL Table - email_log

ahhh, now it makes sense.

Using explorer or the mac finder, browse to the sites testing server location and delete the _mmServerScripts folder.


this will force Dreamweaver to recreate the column list for the email log table.

I did the following...

1. Closed Dreamweaver CS3 (DW) for Windows.
2. Removed UE v.4.0.0 completely with DW Ext. Mgr.
3. Downloaded & Installed UE v.4.0.1
4. Deleted the _mmServerScripts on both the production and development locations.
5. Deleted the WINFILECACHE file from the Configuration directory.
6. Deleted the SiteCache directory as well.

Restarted DW

Same result. I am not seeing a REFRESH of the table in the Create New Message - Configure Email Logging option. The table structure remains rigid.

Go to the Dreamweaver Database tab, and expand your connection, then expand the table is the new column listed there?

Check the connection, what server it connecting to?


double check the database on that server to make sure the new column has been added there.

Did you add that column to your existing recordset (selecting it from Server Behaviours > yourRecordset > select the column) or does it not show up in the recordset either?

Neilo, the Universal Email behavior doesnt take a recordset. you select the column name for it to use in the wizard, think in terms of the insert record interface in data assist. you are binding table columns to values.

Yes, that finally took care of the issue. It was determined to not rescan the table without being forced I guess.

Thanks!

Thanks Jason, I always appreciate you giving your time to help throw a little light on these things for me! I do learn (slowly) but should learn first to think before I post. (Others might agree).