|
My First Forum - a bulletin board application
You are here: irt.org | Articles | Database | My First Forum - a bulletin board application Published on: Thursday 8th April 1999 By: Andrew Shatwell |
<CFINCLUDE TEMPLATE="check.cfm"> <CFQUERY NAME="ArticleDetails" DATASOURCE="#MyDatabase#"> SELECT * FROM tblArticles WHERE ArticleID = #ArticleID# </CFQUERY> <CFIF login.email eq ArticleDetails.UserEmail> <CFQUERY NAME="DeleteArticle" DATASOURCE="#MyDatabase#"> DELETE FROM tblArticles WHERE ArticleID = #articleID# </CFQUERY> |
The email address of the user and the author of the message are compared once again. If they match the article is deleted from the tblArticles table.
<CFQUERY NAME="CountArticles" DATASOURCE="#MyDatabase#">
SELECT * FROM tblArticles WHERE ThreadID = #ArticleDetails.ThreadID#
</CFQUERY>
<CFIF CountArticles.recordcount eq 0>
<CFQUERY NAME="DeleteThread" DATASOURCE="#MyDatabase#">
DELETE FROM tblthreads WHERE ThreadID = #ArticleDetails.ThreadID#
</CFQUERY>
</CFIF>
</CFIF>
<CFLOCATION URL="openthread.cfm?forum=#ArticleDetails.GroupID#&ThreadId=#ArticleDetails.ThreadID#">
|
The CountArticles query the number of other articles in this thread. If the thread is now empty then the DeleteThread query erases it from the tblThread table.
Finally, the CFLOCATION tag returns the user back to the screen showing the other messages in this thread. If the thread no longer exists, the openthread.cfm file will redirect the user to the openforum.cfm screen where they can view articles in other threads.
Back to Cancelling a message - part 1, or forward to Logging on
Feedback on 'My First Forum - a bulletin board application'
- My First Forum - a bulletin board application - carlos 06:21:28 5/17/01
- My First Forum - a bulletin board application - CB Butler 09:53:04 8/30/00
- My First Forum - a bulletin board application - Jetaime 08:42:01 8/18/00
- My First Forum - a bulletin board application - Robert P. 12:50:10 7/20/00
- My First Forum - a bulletin board application - R�mi van der Deure 17:14:28 6/18/00
- My First Forum - a bulletin board application - Margaret Le 15:02:51 6/08/00
- My First Forum - a bulletin board application - Michael Appenzellar 16:11:40 3/29/00
- My First Forum - a bulletin board application - Vanya Loroch 10:49:50 3/09/00
- My First Forum - a bulletin board application - Emilio 14:37:51 11/02/99
- My First Forum - a bulletin board application - Novianingrum 23:35:22 9/22/99
- My First Forum - a bulletin board application - Daniel Iversen 04:53:34 8/19/99
- My First Forum - a bulletin board application - C Gardner 08:43:58 4/12/99
View the author profiles.
irt.org liability, trademark, document use, privacy statement and software licensing rules apply.