* This is the modus mailing list * But what I actually did, was make a table called MailLists that has these fields ID, FullName, EmailAddress, ListID
The ID field is a primary unique key just for my web interface. FullName and EmailAddress are self explanitory. ListID is a varchar field that might have a value like "[EMAIL PROTECTED]" The query I use for my db list is "SELECT EmailAddress, FullName FROM MailLists WHERE MailLists.ListID = '[EMAIL PROTECTED]'" where [EMAIL PROTECTED] is the name of the list this query is for. This way, I can store all my mailing list memberships in one table of the database for management with my web based frontend. I have another table that holds the names of the database mailing lists, so I don't have to rely on people typing the name of the list properly. That table is populated automagically by a registry export DTS transaction and webservice that I wrote. Basically, it's a web page that just exports a comma-delimited list of the database mailing lists that reside in the registry. My DTS transaction then grabs this web data and saves it as a text file for parsing into the database table. Sounds complex but its really quite simple. Jim Barstow Sr. Network Engineer Diversified Solutions and Services, Inc. 22645 Canal Road, Suite B Orange Beach, AL 36561 251.980.8968 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Barstow Sent: Wednesday, January 21, 2004 6:29 PM To: [EMAIL PROTECTED] Subject: [Modus] using sql to select from an existing database was:------> web based listserv signup * This is the modus mailing list * SELECT lastname AS fullname, emailaddr AS emailaddress FROM dbo.existingtable I think that is what you are trying to do. Jim Barstow Sr. Network Engineer Diversified Solutions and Services, Inc. 22645 Canal Road, Suite B Orange Beach, AL 36561 251.980.8968 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Payer Sent: Wednesday, January 21, 2004 6:16 PM To: [EMAIL PROTECTED] Subject: [Modus] using sql to select from an existing database was:------> web based listserv signup * This is the modus mailing list * This starts to get a bit off topic but is it possible to alias field names or columns of an existing database so a query using fullname and emailaddress as columns would actually select from an existing db with the column name: lastname and emailaddr This would allow one to point to an existing DB and not have to create a separate one for each list I am not terribly conversant in SQL, as you can tell. David Payer ----- Original Message ----- From: "Jim Barstow" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 5:50 PM Subject: [Modus] web based listserv signup > * This is the modus mailing list * > > This worked for me this time.. Not sure why I had so many problems > last time I tried it. Anyways, is there a way to gather the data for > the Send, Receive, and DontReceiveOwnPost items? If so, what format > should the results be in? > > > Jim Barstow > Sr. Network Engineer > Diversified Solutions and Services, Inc. > 22645 Canal Road, Suite B > Orange Beach, AL 36561 > 251.980.8968 > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Yves > Sent: Wednesday, January 21, 2004 4:29 PM > To: [EMAIL PROTECTED] > Subject: [Modus] web based listserv signup > > > * This is the modus mailing list * > > Okay here goes ... > > > > Here's the database format. > > 1) Database format ... > > For the database, you need two fields at a minimum: a membername field > (ie: Email of the member) and a fullname field Ex: > > table: aList > mAddress, type text/varchar > mFullname, type text/varchar > > You create a system DSN that points to the DB containing the aList > table. > > Populate it with a couple of test members. > > aList > mAddress mFullname > [EMAIL PROTECTED] Yves Lacombe > [EMAIL PROTECTED] John Troher > > Once you've populated the list with a couple of test members ... > > You go into ModusConsole, lists, create your new list as a database > mailing list, in "Database Config", you put in the system DSN, the DSN > username/password if applicable, and you define your select statement. > With the above example: > > SELECT mAddress,mFullname FROM aList > > Click on Apply and go to members, you should see the members pop up. > > You should index the mAddress field. > > -- > Yves Lacombe > Vircom Technical Support > > > > ----- Original Message ----- > From: "Peter Wimbourne" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 5:27 PM > Subject: [Modus] web based listserv signup > > > > * This is the modus mailing list * > > > > Thanks John, > > > > hmmm....can you point me at some live examples? > > > > regards > > > > - peter > > > > "John M. Troher" wrote: > > > > > * This is the modus mailing list * > > > > > > Use a mailer object like aspmail, or abmailer, or even a perl > > > script > > > > that format the email at the server side and mails it from the > > > server side when they submit. > > > > > > John > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > On Behalf Of Peter Wimbourne > > > Sent: Wednesday, January 21, 2004 4:19 PM > > > To: [EMAIL PROTECTED] > > > Subject: [Modus] web based listserv signup > > > > > > * This is the modus mailing list * > > > > > > Greetings all, we've got a problem that we've been limping along > > > with for sometime. We want to have a sign-up form on a website for > > > people to join a Modus based listserv. The problem is that if we > > > use > > > > a mailto link it results in the mailer on the user's computer > > > opening and sending [EMAIL PROTECTED] address, when the user > > > entered a [EMAIL PROTECTED] address in the form. > > > > > > If we use POST we end up with the Modus listserv getting the > > > address > > > > from the smtp server that sends the form. > > > > > > Help? Anyone done this successfully? is the answer right in front > > > of > > > > me? > > > > > > thanks > > > > > > - peter wimbourne > > > > > > ** > > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with > > > the word "UNSUBSCRIBE" in the body or subject line. > > > > > > ** > > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with > > > the word "UNSUBSCRIBE" in the body or subject line. > > > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > > word "UNSUBSCRIBE" in the body or subject line. > > > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > word "UNSUBSCRIBE" in the body or subject line. > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
