Listing 1: qryGetEmployees.cfm
<!---
<fusedoc fuse="qryGetEmployees.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I return a recordset of employee data.
</responsibilities>
<io>
<out>
<recordset name="qryGetEmployees">
<number name="employeeID" />
<string name="firstName" />
<string name="lastName" />
<string name="department" />
<number name="supervisorID" />
</recordset>
</out>
</io>
</fusedoc>
--->
<cfquery name="qryGetEmployees" datasource="personnel" dbtype="ODBC">
SELECT employeeID,
firstName,
lastName,
department,
supervisorID
FROM Employees
ORDER BY department,
employeeID
</cfquery>
Listing 2: dspEmployees.cfm
<!---
<fusedoc fuse="dspEmployees.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I display a table with employee information sorted by department.
For each employee, I display the full name and the supervisor's ID.
</responsibilities>
<io>
<in>
<recordset name="qryGetEmployees">
<number name="employeeID" />
<string name="firstName" />
<string name="lastName" />
<string name="department" />
<number name="supervisorID" />
</recordset>
</in>
</io>
</fusedoc>
--->
<table>
<cfoutput query="qryGetEmployees" group="department">
<tr>
<td>
<h3>#UCase(department)#
</td>
</tr>
<cfoutput>
<tr>
<td>#employeeID#: #firstName# #lastName# Supv: #supervisorID#</td>
</tr>
</cfoutput>
</cfoutput>
</table>
Listing 3: exampleOne.cfm
<cfinclude template="qryGetEmployees.cfm">
<cfinclude template="dspEmployees.cfm">
Listing 4: qryGetEmployees.cfm using <cf_querysim>
<!---
<fusedoc fuse="qryGetEmployees.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I return a recordset of employee data.
</responsibilities>
<io>
<out>
<recordset name="qryGetEmployees">
<number name="employeeID" />
<string name="firstName" />
<string name="lastName" />
<string name="department" />
<number name="supervisorID" />
</recordset>
</out>
</io>
</fusedoc>
--->
<cf_querysim>
qryGetEmployees
employeeID,firstName,lastName,department,supervisorID
8|Helen Hotel|ENGINEERING|2
2|Belinda|Baker|MANAGEMENT|0
4|Deborah|Delta|MARKETING|2
5|Eugene|Echo|MARKETING|4
6|Francine|Foxtrot|MARKETING|4
7|Gary|Golf|MARKETING|4
1|Andy|Able|SALES|3
3|Charlie|Charlie|SALES|2
</cf_querysim>
Listing 5: Using <cf_querysim> to simplify create/edit forms
<!---
<fusedoc fuse="dspUserForm.cfm" language="ColdFusion" specification="2.0">
<responsibilities>
I display a for to edit a user's record.
</responsibilities>
<io>
<in>
<recordset name="qryGetUser" comments="If empty, create querysim with a blank row">
<string name="email" />
<string name="firstName" />
<string name="lastname" />
</recordset>
</in>
<out>
<string name="email" scope="form" />
<string name="firstName" scope="form" />
<string name="lastname" scope="form" />
</out>
</io>
</fusedoc>
--->
<cfif not qryGetUser.recordCount>
<cf_querysim>
qryGetUser
email,firstName,lastName
null|null|null
</cf_querysim>
</cfif>
<form action="#self#?fuseaction=updateUser" method="post">
<cfoutput query="qryGetUser">
E-mail: <input type="text" name="email" value="#qryGetUser.email#"><br>
First Name: <input type="text" name="firstName" value="#qryGetUser.firstName#"><br>
Last Name" <input type="text" name="lastname" value="#qryGetUser.lastName#"><br>
<input type="submit">
</form>
Listing 6: Querysim for WorkLog
<!---
<fusedoc fuse="qryGetWorkLog.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I return a recordset of work log entries.
</responsibilities>
<io>
<out>
<recordset name="qryGetWorkLog">
<datetime name="itemDate" />
<string name="itemText" />
</recordset>
</out>
</io>
</fusedoc>
--->
<cf_querysim>
qryGetWorkLog
itemDate,itemText
25 Mar 02|Created new training table
26 Mar 02|Worked on user training edits
26 Mar 02|Inserted an alert message in the onload event of the form
if the qry resulted in no records
26 Mar 02|Checked validation requirements on forms to ensure that
at least one field must be filled in before submitting
26 Mar 02|Conducted training session
26 Mar 02|Developed Oracle SQL queries and procedures for the Widgets circuit
26 Mar 02|Modified the Widgets module to show line items in a
grouped listing
26 Mar 02|Tested changes to Widgets module
26 Mar 02|Prepared matrix of user roles/functions
</cf_querysim>
Listing 7: Display file for WorkLog
<!---
<fusedoc fuse="dspWorkLog.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I display work log entries by date.
</responsibilities>
<io>
<out>
<recordset name="qryGetWorkLog">
<datetime name="itemDate" />
<string name="itemText" />
</recordset>
</out>
</io>
</fusedoc>
--->
<link rel="stylesheet" href="WorkLog.css" type="text/css">
<title>Work Log</title>
<body bgcolor="#FFFFCC" text="#006600">
<table width="580" border="0" align="center">
<tr>
<td>
<div align="center" class="pageTitle">Work Log</div>
</td>
</tr>
<tr>
<td> <cfoutput query="qryGetWorkLog" group="itemDate">
<span class="itemDate">#itemDate#</span><br>
<cfoutput> <span class="itemText">- #itemText#</span><br>
</cfoutput>
</cfoutput>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
Listing 8: Querysim with <cfinclude>
<!---
<fusedoc fuse="qryGetWorkLog.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I return a recordset of work log entries.
</responsibilities>
<io>
<out>
<recordset name="qryGetWorkLog">
<datetime name="itemDate" />
<string name="itemText" />
</recordset>
</out>
</io>
</fusedoc>
--->
<cf_querysim>
qryGetWorkLog
itemDate,itemText
<cfinclude template="WorkLog.txt">
</cf_querysim>
Listing 9: WorkLog text file
25 Mar 02|Created new training table
26 Mar 02|Worked on user training edits
26 Mar 02|Inserted an alert message in the onload event of the form
if the qry resulted in no records
26 Mar 02|Checked validation requirements on forms to ensure that
at least one field must be filled in before submitting
26 Mar 02|Conducted training session
26 Mar 02|Developed Oracle SQL queries and procedures for the Widgets circuit
26 Mar 02|Modified the Widgets module to show line items in a
grouped listing
26 Mar 02|Tested changes to Widgets module
26 Mar 02|Prepared matrix of user roles/functions
Listing 10 : Customized Apache access.log
127.0.0.1|-|-|[26/Mar/2002:13:56:56 -0500]|"GET
/test HTTP/1.0"|301|292
127.0.0.1|-|-|[26/Mar/2002:13:56:56 -0500]|"GET
/test/ HTTP/1.0"|200|4286
127.0.0.1|-|-|[26/Mar/2002:13:56:57 -0500]|"GET
/icons/unknown.gif HTTP/1.0"|200|245
127.0.0.1|-|-|[26/Mar/2002:13:56:57 -0500]|"GET
/icons/image2.gif HTTP/1.0"|200|309
127.0.0.1|-|-|[26/Mar/2002:13:56:57 -0500]|"GET
/icons/folder.gif HTTP/1.0"|200|225
127.0.0.1|-|-|[26/Mar/2002:13:56:57 -0500]|"GET
/icons/blank.gif HTTP/1.0"|200|148
127.0.0.1|-|-|[26/Mar/2002:13:56:57 -0500]|"GET
/icons/text.gif HTTP/1.0"|200|229
127.0.0.1|-|-|[26/Mar/2002:13:57:09 -0500]|"GET
/test/Image1.gif HTTP/1.0"|200|805
127.0.0.1|-|-|[26/Mar/2002:13:57:14 -0500]|"GET
/test/addTest.html HTTP/1.0"|200|242
Listing 11: WebLog querysim file
<!---
<fusedoc fuse="qryGetApacheLog.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I return a recordset of Apache access.log entries.
</responsibilities>
<io>
<out>
<recordset name="qryGetApacheLog">
<string name="client_address" />
<string name="userid" />
<string name="request_time" />
<string name="request" />
<string name="response_status" />
<string name="size" />
</recordset>
</out>
</io>
</fusedoc>
--->
<cf_querysim>
qryGetLogs
client_address,ident,userid,request_time,request,response_status,size
<cfinclude template="access.log">
</cf_querysim>
Listing 12: WebLog display file
<!---
<fusedoc fuse="dspApacheLog.cfm" language="ColdFusion" version="2.0">
<responsibilities>
I display an Apache access.log report.
</responsibilities>
<io>
<in>
<recordset name="qryGetApacheLog">
<string name="client_address" />
<string name="userid" />
<string name="request_time" />
<string name="request" />
<string name="response_status" />
<string name="size" />
</recordset>
</in>
</io>
</fusedoc>
--->
<link rel="stylesheet" href="WorkLog.css" type="text/css">
<title>Apache access.log</title>
<body bgcolor="#FFFFCC" text="#006600">
<table width="580" border="0" align="center">
<tr>
<td>
<div align="center" class="pageTitle">Apache access.log</div>
</td>
</tr>
<tr>
<td>
<cfdump var="#qryGetApacheLog#">
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
Listing 13: Calling file for WebLog
<cfinclude template="qryGetApacheLog.cfm">
<cfinclude template="dspApacheLog.cfm">