Toad World® Forums

E-mail issue when using a bind variable for e-mail address in TDP 3.3

Was there a change in TDP 3.3 on how it handles variables for the e-mail address in an automation script?

In TDA 3.1 and earlier I had to put “quotes” around the e-mail address in my sql statement for the list of values to send the e-mailed document to:

Sample:

SELECT COMM_METHOD_TAB.IDENTITY Supplier,
‘"’||COMM_METHOD_TAB.VALUE||’"’ Email,
‘"’||SUPPLIER_INFO_TAB.NAME||’"’ Descr,
COMM_METHOD_TAB.“NAME”
FROM MINC1APP.COMM_METHOD_TAB COMM_METHOD_TAB
INNER JOIN
MINC1APP.SUPPLIER_INFO_TAB SUPPLIER_INFO_TAB
ON (COMM_METHOD_TAB.IDENTITY = SUPPLIER_INFO_TAB.SUPPLIER_ID)
WHERE (COMM_METHOD_TAB.“NAME” = ‘OPENORDER’)
ORDER BY 1

Then the e-mail address would format correctly when sent out. I just discovered that none of our e-mails are going out from scripts using bind variables for the e-mail address. And when selecting forward on an e-mail that was supose to go out I get an address that looks like this: cmesenburg@company.com <"> and it fails. But when removing the quotes from the sql statement I get an even more weird e-mail address.

Anyone have this issue?

You no longer need to put the quotes around the email column. Also, the loop data set activity is a lot easier to use. You will need to add #s around the variable to dereference. i have attached a sample script.

[View:~/cfs-file.ashx/__key/communityserver-discussions-components-files/36/Script_5F00_EmailTest.tas:550:0]