Print Page | Close Window

batch delete users

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=240
Printed Date: 29 March 2026 at 8:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: batch delete users
Posted By: reffael1
Subject: batch delete users
Date Posted: 17 February 2003 at 4:53am

i have many non active registered users in my forum and i'd like to delete them from the database.

i tried this sql sentence
"DELETE FROM tblAuthor WHERE ((tblAuthor.No_of_posts)<5); "

but because of the constrains i got error message, how can i remove the constrains or bypass them? 




Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 February 2003 at 7:30am

You are better off just deleting those people who have never posted.

If you remove the relationships between the tables to force the deletion of poeple who have posted less than 5 posts you will find that any topic that someone has posted in that you have delted the account of won't be viewable and you will end up with a forum that crashes all over the place.



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: reffael1
Date Posted: 19 February 2003 at 7:03am
but if i add to the sql sentence, condition to delete only if the user didn't send message in the last month, and i delete all the emessages older than one month this should work, am i right or am i wrong?


Posted By: WebWiz-Bruce
Date Posted: 19 February 2003 at 1:12pm
No, you can not delete any member that has made a post, or the forum simply won't run.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net