The check.cfm file

Check.cfm is a file that is included at the start of most of the Cold Fusion scripts. It checks whether the user has logged on and sets the variable log accordingly. Other scripts check the value of log and amend their output to follow suit. The query also retrieves other information about the user, such as their name and email address.

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

The check.cfm file
Application.cfm

<CFSET log = 0>

<CFIF #isDefined("Fwho")#>
  <CFQUERY NAME="login" DATASOURCE="#MyDatabase#">
    SELECT * FROM Users WHERE Username = '#Fwho#'
  </CFQUERY>
  <CFIF #login.recordcount# eq 1>
    <CFSET log = 1>
  </CFIF>
</CFIF>

Fwho is the user's ID and is stored in a cookie when they first log on.

If the cookie doesn't exist then the user has not logged on.	*log = 0*
If the ID stored in the cookie matches one in the database then the user has logged on.	*log = 1*
If the ID stored in the cookie doesn't match the database then the user has not logged on.	*log = 0*

Application.cfm

Each time Cold Fusion runs a script it searches the current directory and those above it for a file called application.cfm. If found, then this file is run first. It's beyond the scope of this document to go into great details about application.cfm, however some of its uses are:

Declaring default variables and application-level constants
Creating custom error messages

<!-- Set the value of MyDatabase to be the name you published the database under -->
<CFSET MyDatabase="ForumDatabase">

Our application.cfm only has one entry. This sets a global variable, MyDatabase, to be the name that the database is published under. The value of this variable is used in all CFQUERY tags.

Back to Displaying the forums, or forward to Opening a group

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.

What's New

How to do the impossible with Google Gears

Out and About

Last Updated: 21st December 2007. Maintained by: Martin Webb
irt.org liability, trademark, document use, privacy statement and software licensing rules apply.

Copyright © 1996-2008 irt.org, All Rights Reserved.