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

Re: [YoYoYoYo] Delete Users but not their Links

Jul 19, 2002, 9:40 AM
pugdog
Veteran / Moderator (6956 posts)
Jul 19, 2002, 9:40 AM
Views: 2022
Shortcut
Quote Reply
Re: [YoYoYoYo] Delete Users but not their Links In reply to
The *easy* way may be to null out the fk lines in Links.def and/or Users.def

As for updating the user to Admin, you'd need to do that manually, from the SQL Monitor.

Not sure the effect of this action :)

The *BEST* way would be to go to the SQL Monitor, and

UPDATE prefix_Links Set LinkOwner = 'Admin' where LinkOwner = "BadUser"

Then delete the user. By changing the LinkOwner, the "BadUser" no longer has any ties to the Links table.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Subject Author Views Date
Thread Delete Users but not their Links YoYoYoYo 2121 Jul 19, 2002, 2:28 AM
Post Re: [YoYoYoYo] Delete Users but not their Links 		pugdog 2022 Jul 19, 2002, 9:40 AM
Thread Re: [YoYoYoYo] Delete Users but not their Links 		Troja 2026 Jul 20, 2002, 5:03 PM
Thread Re: [Troja] Delete Users but not their Links 		yogi 2030 Jul 21, 2002, 4:14 AM
Post Re: [yogi] Delete Users but not their Links 		YoYoYoYo 2009 Jul 21, 2002, 4:28 AM