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

Status Change

Jun 4, 2002, 7:15 PM
katabd
Veteran (1187 posts)
Jun 4, 2002, 7:15 PM
Post #1 of 3
Views: 1429
Shortcut
Quote Reply
Status Change
Hi

what is the SQL Query to change all users status from Not Validated to Registered?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Jun 4, 2002, 7:30 PM
Ian
Veteran / Moderator (2577 posts)
Jun 4, 2002, 7:30 PM
Post #2 of 3
Views: 1368
Shortcut
Quote Reply
Re: [katabd] Status Change In reply to
UPDATE lsql_Users SET Status = 'Registered' WHERE Status = 'Not Validated';

Something like that...


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Jun 4, 2002, 7:31 PM
Jun 4, 2002, 7:41 PM
katabd
Veteran (1187 posts)
Jun 4, 2002, 7:41 PM
Post #3 of 3
Views: 1343
Shortcut
Quote Reply
Re: [Ian] Status Change In reply to
Thanks

works great
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory