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