Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 wipe out n/a		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tcadieux
Junior Member

153 Posts
Posted - 15 April 2006 :  13:49:36  Show Profile
I've been deleting Inactive members to try and keep the DB small, so i'd like to be able to run a Query that would rename all members named N/A to Deleted User?

Podge
Support Moderator

Ireland
3775 Posts
Posted - 15 April 2006 :  13:54:21  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Wouldn't that increase the size of the db (slightly) ? Which database are you using ?
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

tcadieux
Junior Member

153 Posts
Posted - 17 April 2006 :  15:20:46  Show Profile
Access 2000
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 17 April 2006 :  19:40:56  Show Profile  Visit Gremlin's Homepage
You just want to run an update query, SET M_NAME = 'Deleted User' WHERE M_Name = 'n/a' Run against the FORUM_MEMBERS Table.

Do you know how to run ad-hoc queries or updates to your database?
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07