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/
