Forums :: Advanced Mail :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Advanced Mail

DwZone Forum Index -> Advanced Mail

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 381 to 390 of 781 (Total: 224)

First | Prev | Next | Last

Subject

Author

Date

Formating html email

[email protected]

19:10 3 May 2006

Re:Formating html email

gianluigi

19:59 3 May 2006

Send mail using CDOSYS

[email protected]

16:50 26 Apr 2006

Re:Send mail using CDOSYS

gianluigi

18:01 26 Apr 2006

Problem with Temp Directory

[email protected]

21:56 10 Apr 2006

Re:Problem with Temp Directory

gianluigi

19:19 11 Apr 2006

Send ignored SQL statement

[email protected]

16:01 5 Apr 2006

I send out an HTML e-mail newsletter to members of a site. Some of the members don't have a valid e-mail address registered so I added a field in the db just to sort them out, it's a imple 1 0r 0 for valid or not.

The SQL in Adv mail looks like this:
"SELECT rsCompany.coComp, rsCompany.coFname, rsCompany.coEname, rsCompany.coEmail, coPassword, coUserlevel FROM rsCompany WHERE rsCompany.coAktivated ='1' AND coNomail = '1'"

coNomail means: 1 = valid and 0 = not valid

Despite this, after my first email I got a whole bunch of returns stating that a lot of members had no valid email and therefor could not be reached. I checked the list against the database (MySql) and discovered that they were all from the "not valid" list, a "noMail= '0'" Basically, I was sending out to all the members despite of the SQL statement. Im afraid it also sent to those that were not activated but this I cannot check. Can I trust Advanced Mail? What went wrong?
(the WHERE statements are not included in the SELECT list, but normally you don't need to do that, or do I?)
//Bjorn