Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

SQL Monitor and E-mail notification

Oct 18, 2001, 11:30 PM
Vs_Greg
User (359 posts)
Oct 18, 2001, 11:30 PM
Post #1 of 4
Views: 1776
Shortcut
Quote Reply
SQL Monitor and E-mail notification
Hi!

i wonder if there is kinda sql query command to set all links in database which have i.e. email@email.email adress to not to receive "Links Users" messages
To do this manually for 4000 links would be little hard and difficult and long :)

thanx

Gregor
Oct 20, 2001, 10:09 AM
Vs_Greg
User (359 posts)
Oct 20, 2001, 10:09 AM
Post #2 of 4
Views: 1695
Shortcut
Quote Reply
Re: [sc2utp] SQL Monitor and E-mail notification In reply to
Hi!

i'm no mysql freak and i wonder if i could use this command
Code:
UPDATE Users SET Status='Registered' WHERE Status='Not Validated';

for assigning receivemail to "No" for one User ...

Gregor
Oct 22, 2001, 11:14 AM
Alex
Administrator (9387 posts)
Oct 22, 2001, 11:14 AM
Post #3 of 4
Views: 1707
Shortcut
Quote Reply
Re: [sc2utp] SQL Monitor and E-mail notification In reply to
Hi,

UPDATE Links SET ReceiveMail = 'No' WHERE Contact_Email = 'email@email.email'

Cheers,

Alex
--
Gossamer Threads Inc.
Oct 22, 2001, 11:20 AM
Vs_Greg
User (359 posts)
Oct 22, 2001, 11:20 AM
Post #4 of 4
Views: 1696
Shortcut
Quote Reply
Re: [Alex] SQL Monitor and E-mail notification In reply to
thanx
wonderful..

Gregor