JavaSctipr Error When Using Database Insert
I'm using Universal Email 4.01 on Dw CS4
Every time I use UE to send the data from the form for a database insert on Success for a specific column I get the following error "While executing applyServerBehavior in CreatEmailMessage_WA.htm, a JavaScript error occurred."
I did the whole 'delete the cache file' thing with no results.
I was successful with inserting two columns of data but when I add the actual email column the JavaScript error consistently shows up.
I was able to get a workaround by manually editing the 'waue_e-book_1.php' file that is generated that contains the code that sets variables for database insert on success.
It now works but I get a warning dialog when I open the UE GUI that says:
"It appears that one of your server-side values is improperly coded. Please check this interface for inconsistencies."
Any ideas how to properly fix this?
NON-WORKING CODE BLOCK:
$MailLogBindings->Success->ToDo = "insert";
$MailLogBindings->Success->Connection = "connBackOffice";
$MailLogBindings->Success->TableName = "ileads";
$MailLogBindings->Success->EmailColumn = "email";
$MailLogBindings->Success->ColumnList = array("ilead_type", "date_create");
$MailLogBindings->Success->TypeList = array("',none,''", "',none,NULL");
$MailLogBindings->Success->ValueList = array("Savvy Investor e-Book", "".date('Y-m-d') ."");
MODIFIED WORK-AROUND CODE BLOCK
$MailLogBindings->Success->ToDo = "insert";
$MailLogBindings->Success->Connection = "connBackOffice";
$MailLogBindings->Success->TableName = "ileads";
$MailLogBindings->Success->EmailColumn = "email";
$MailLogBindings->Success->ColumnList = array("ilead_type", "date_create", "email");
$MailLogBindings->Success->TypeList = array("',none,''", "',none,NULL", "',none,NULL");
$MailLogBindings->Success->ValueList = array("Savvy Investor e-Book", "".date('Y-m-d') ."", "".((isset($_POST["email_address"]))?$_POST["email_address"]:"")."");