* This is the modus mailing list * I could get fancy...
SELECT firstname + ' ' + lastname AS fullname, username + '@' + domain AS emailaddress FROM somebillingdatabase Is kinda what I do on my system. I have some lists that are FAR more extravegant then that though, where they do conditional selections based on the data and all kinds of good stuff. 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:46 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 * AS Thanks! That seems to be the item I was looking for. Ahhh, the power of adverbs. David P. ----- Original Message ----- From: "Jim Barstow" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 6:28 PM 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. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
