[Modus] Database Mailing Lists

[Suneel Jhangiani]

Title: Message

That select statement won’t work as you should get an invalid object error (I doubt you have an object in your SQL Database called [EMAIL PROTECTED]).   If you want to force a single address try the following statement:   --- SELECT '[EMAIL PROTECTED]' as EmailAddress, 'Mr. Test Tester' as FullName ---   Also, sometimes people have additional spaces on there data that they don’t realise, so I recommend using something like the following:   --- SELECT LTRIM(RTRIM(Email)) as EmailAddress, LTRIM(RTRIM(Title)) + ‘ ‘ + LTRIM(RTRIM(Forename)) + ‘ ‘ + LTRIM(RTRIM(Lastname)) as FullName FROM Users WHERE newsletter = 1 ---   The above query is taken directly from a working list.     ----- Drag me, drop me, treat me like an object!  (--------------------------------)         {(((((((     Suneel Jhangiani           )        /_  _  )(    Technical Director          )       ( .  .   )( Inter-Computer Technology Ltd. )        ( /   )(----------------------------------oOOo------------oOOo----)( 40 James Street                Tel: +44 (0) 20 7486 9601 ) ( London W1U 1EU                 Fax: +44 (0) 7050 678 978 )( United Kingdom               Email: [EMAIL PROTECTED]     )(             Website: http://www.inctech.com              ) (----------------------------------------------------------) From: Jim Barstow [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:48 To: [EMAIL PROTECTED] Subject: [Modus] Database Mailing Lists   Yeah, I was just hoping there was some way to set the value of those 3 checkboxes (Send, Recieve, DontReceiveOwnPost) from the database table as well...   I havent had much luck making these work anyways.. I have my ODBC connection setup properly, and when I run the query via query analyzer it returns the results I would expect, but for the life of me, I cannot get ModusMail to pull the list membership from the database.   I have even tried hard coding the sql query SELECT EmailAddress, FullName FROM [EMAIL PROTECTED] which, from what I understand, is what it would try to do if I didnt fill in anything for the sql statement.   Sr. Network Engineer Diversified Solutions and Services, Inc. 22645 Canal Road, Suite B Orange Beach, AL 36561 (251)980-8968