Gossamer Forum
Home : Products : Gossamer Links : Discussions :

add all to newsletter in one command?

Quote Reply
add all to newsletter in one command?
Hi there -

What command would I use to make all users set to 'yes' to accept newsletter?

I am trying to avoid doing all of these one by one - yuk!

Last edited by:

SSmeredith: Sep 22, 2003, 9:05 AM
Quote Reply
Re: [SSmeredith] add all to newsletter in one command? In reply to
If you want to update all of the users, you can go to the SQL Monitor and use:

Update lsql_Users
Set Newsletter = 'Yes'

This would update assume that the prefix you use for your Links SQL tables is 'lsql_'.

--Frank
Quote Reply
Re: [FrankM] add all to newsletter in one command? In reply to
Well that was painless enough - thanks Frank!
Quote Reply
Re: [SSmeredith] add all to newsletter in one command? In reply to
can you put a little detail on how to do this again. Thanks so much.
Quote Reply
Re: [4x4search] add all to newsletter in one command? In reply to
Hi - I didn't see ths reply back then...You'll need the help you just need to go the your links admin and go to Database> SQL Monitor and then copy and paste the query above. That's it.
Quote Reply
Re: [FrankM] add all to newsletter in one command? In reply to
FrankM wrote:
If you want to update all of the users, you can go to the SQL Monitor and use:

Update lsql_Users
Set Newsletter = 'Yes'

This would update assume that the prefix you use for your Links SQL tables is 'lsql_'.

--Frank

Hm, was there a change in gossamer links 3 ???
In my links installation there is no Newsletter column in the user table!
And I think there is a difference between "Recieve Mail" set to Yes and "Newsletter" set to Yes.

So how can I update all users to recieve newsletters.
And it would be perfect to set recieve newsletter to Yes when the user register with g-community.

Thanks
Matthias

Matthias
gpaed.de