Home Articles FAQs XREF Games Software Instant Books BBS About FOLDOC RFCs Feedback Sitemap
irt.Org

Related items

Exporting data to Word with Cold Fusion

How to update/edit data using Cold Fusion

Introduction to Cold Fusion

Diary of a WebObjects Developer

Building an Internet Database

My First Forum - a bulletin board application- index3

You are here: irt.org | Articles | Database | My First Forum - a bulletin board application [ previous next ]

Published on: Thursday 8th April 1999 By: Andrew Shatwell

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.

<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:

<!-- 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

Related items

Exporting data to Word with Cold Fusion

How to update/edit data using Cold Fusion

Introduction to Cold Fusion

Diary of a WebObjects Developer

Building an Internet Database

©2018 Martin Webb