Hey Dennis, This is an automated notification. It runs 24 hours a day, seven days a week with noone watching it. Thanks for the choose advice, I can use that for an upgrade for something else I did.
>From: Dennis Fleming <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: Select Question >Date: Mon, 29 Jul 2002 11:01:08 -0400 > >CHOOSE vnam FROM #VALUES ... > >The popup will allow you to load your variable with any/all selections >separated by commas. > >dennis >***** > > > >At 10:31 AM 7/29/02 -0400, you wrote: > >Hi all, > > > >I am selecting multiple rows, for example, I have an automated email > >notification system running. I have more than one email address being > >inserted into the TO: column of the email. The select command looks > >something like this: > > > >SELECT ename,edomain,edcom, into vnam,vdom,vddcom from emailtable where >id = > >'l' > > > >Now I have more than one email address to insert, so right now I am using >a > >while loop. Is there a shorter way to do this? I would like to select all > >the names, into one varible, and have a comma between each name. Any help >is > >appreciated. Thanks > > > >SD > > > >_________________________________________________________________ > >Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > >Dennis Fleming >IISCO >http://www.TheBestCMMS.com >Phone: 570 775-7593 >Fax: 570 775-9797 >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
