Re: [Emerald] Emerald & Mailsite Lists

PowerNet ( (no email) )
Tue, 29 Jun 1999 17:14:41 -0400

I have nothing in the SQL statement.

What should I put?

*********** REPLY SEPARATOR ***********

On 6/29/99, at 1:00 PM, Dale E. Reed Jr. wrote:

>PowerNet wrote:
>>
>> I am trying to create a mail list from my Emerald database
>> I do not want users to be able to post here.
>> This is for my use only for things like newsletters.
>>
>> I followed the instructions.
>> I am using mailsite 3 with Emerald database.
>> I created the new list, then went to configuration.
>> Completed the general tab and then the database tab.
>> When I click on members, it should show my entire database, but I get=
this error:
>>
>> Cannot load mail list members
>> Error: 0xE120FFFF
>> Mail list manager error
>> Invalid object name 'list'
>> State: S0002, Native:208, Origin:[Microsoft][ODBC SQL Server Driver][SQL=
Error]
>>
>> The name of my list is "list"
>
>
>I remember a problem with this. What did you put in for the
>SQL statement? I belive you have to apply/reload the list
>configuration after updating the SQL statement before you can
>use the members tab.
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart