|
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> |
This is the last script to include the check.cfm file.
The ArticleDetails query retrieves information about to the article referenced in the URL.
<CFIF login.email eq ArticleDetails.UserEmail>
<!doctype html public "-//IETF//DTD HTML 3.2//EN">
<html>
<head>
<title>My First Forum</title>
<meta name="Generator" content="HTMLed32 Version 2.0a">
<meta name="Author" content="Andrew Shatwell">
</head>
<body BGCOLOR="#FFFFFF" BACKGROUND="../images/gridpaperbackground2.gif" link="#000080" vlink="#2f2f4f">
<div align="center">
<IMG SRC="../images/logo2.gif" BORDER="0" ALT="My First Forum" width="469" height="64">
</div>
<p>
<b>Cancel:</b>
<font color="#000080"><b><CFOUTPUT>#ArticleDetails.ThreadName#</CFOUTPUT></b></font>
<p>
<table cellpadding="1" border="0" width="95%">
<tr bgcolor="#D5E6E1">
<td NOWRAP width="18%" valign="top"><FONT SIZE="1" face="Verdana, Arial" color="#000080">Name</font></td>
<td valign="top" width="82%"><FONT SIZE="1" face="Verdana, Arial" color="#000080">Post</font></td></tr>
<CFOUTPUT QUERY="ArticleDetails">
<tr>
<td align="left" valign="top">
<FONT size="2" face="Verdana, Arial" ><b>#UserName#</b>
</td>
<td>
<FONT SIZE="1" face="Verdana, Arial" color="##000080">
<img src="../images/posticon.gif" width="14" height="11" border="0">
Posted on #dateformat(Posted,"dd-mm-yy")# #timeformat(Posted,"h:mm tt")#
</font>
<br><hr>
<FONT SIZE="2" face="Verdana, Arial">#paragraphformat(Message)#
</td>
</tr>
</CFOUTPUT>
</table>
<div align="center">
<form>
<CFOUTPUT><input type="button" value="Delete this message" onClick="location.href='Cancelmess.cfm?ArticleID=#ArticleID#'">
<input type="Button" value="Cancel" onClick="location.href='openthread.cfm?forum=#ArticleDetails.GroupID#&ThreadId=#ArticleDetails.ThreadID#'">
</CFOUTPUT>
</body>
</html>
|
The first CFIF statement tests if the email address of the user currently logged on matches that of the author of the article. If the two addresses match then the article is displayed. The form at the bottom of the code passes the ID number of the article to the cancelmess.cfm file which contains the Cold Fusion script that actually deletes the article.
<CFELSE> <CFLOCATION URL="openthread.cfm?forum=#ArticleDetails.GroupID#&ThreadId=#ArticleDetails.ThreadID#"> </CFIF> |
If the email address of the user does not match that belonging to the article then the CFLOCATION statement redirects the server back to the message screen.
Back to Replying to a message - part 2, or forward to Cancelling a message - part 2
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.