* 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.
