Hi,
I have an email trigger set up that pulls the body of the triggered email and loops through each line to pull out the required data. This email is an end user asking me to run a number of queries against a database. For example, this is a single line of the email:
UPDATE <tablename> SET <fieldname1> = TO_DATE('08/11/2019 12:01:00', 'MM/DD/YYYY HH24:MI:SS'), <fieldname2> = '1', <fieldname3> = TO_DATE('08/11/2019 12:01:00', 'MM/DD/YYYY HH24:MI:SS') where <idfield> = '1715851'; -- #07 CI = CO need to be different
Since the email contains more than just these queries, the job loops through each line and pulls out any line starting with "UPDATE" or "EXECUTE". But when VC sees the email body, the queries look like this:
SS3.png
(269kb) downloaded 40 time(s).Since VC is somehow splitting them onto multiple lines, what I'm pulling out is excluding part of the query. Any idea why VC is misinterpreting the email body?
Thanks.