on one hand u use this table for counting the mails that were sent on a mailing
Code: Select all
String query = "INSERT INTO " + data.mailtracking_table + " " +
"(company_id, status_id, mailing_id, customer_id) " +
"SELECT " + data.company_id + ", " + data.maildrop_status_id + ", " + data.mailing_id + ", cust.customer_id " +
get_fromclause () + " " +
get_whereclause (true);
and u also use it in the softbounce script
Code: Select all
iquery = 'INSERT INTO mailtrack_tbl (customer_id, company_id, mailing_id, status_id, change_date) '
iquery += 'VALUES (:customer, :company, :mailing, 90, now())'
This does not seem OK. Am i wrong?